WIS_WD_OPERATIONS_B

-- ============================================================
-- Table  : WIS_WD_OPERATIONS_B — Work definition operations — the ordered, date-effective steps of a work definition, each pointing at the work center where it runs and optionally at a reusable standard operation
-- Purpose: Column-selected read of WIS_WD_OPERATIONS_B — auto-generated from field metadata
-- Grain  : One row per WD_OPERATION_ID
-- Caution: Operation rows are effectivity slices (EFFECTIVE_FROM_DATE/EFFECTIVE_TO_DATE) — filter the window you mean or steps multiply
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.WD_OPERATION_ID AS "Surrogate key of the operation row",
  t.WORK_DEFINITION_ID AS "Parent work definition header",
  t.OPERATION_SEQ_NUMBER AS "Execution order within the definition",
  t.OPERATION_TYPE AS "In-house vs supplier operation",  -- decode t.OPERATION_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_OPERATION_TYPE', LANGUAGE-filtered)
  t.WORK_CENTER_ID AS "Work center where the operation runs",
  t.EFFECTIVE_FROM_DATE AS "Start of this operation row's effectivity slice",
  t.EFFECTIVE_TO_DATE AS "End of the slice — NULL while open",
  t.STANDARD_OPERATION_ID AS "The reusable standard operation referenced, when one is",
  t.COUNT_POINT_FLAG AS "Completion must be explicitly reported at this step",
  t.AUTO_TRANSACT_FLAG AS "Materials and resources auto-charge at this step",
  t.OP_YIELD_FACTOR AS "Fraction of starting quantity yielded (1 = 100%)",
  t.SUPPLIER_ID AS "Suggested supplier for supplier operations",
  t.OSP_ITEM_ID AS "Outside-processing service item for supplier operations"
FROM <catalog>.<schema>.WIS_WD_OPERATIONS_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.WD_OPERATION_ID = <WD_OPERATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WD_OPERATION_ID;