MTL_CROSS_REFERENCES_B

-- ============================================================
-- Table  : MTL_CROSS_REFERENCES_B — Item cross-references — maps items to external identifiers (GTINs, superseded part numbers, customer and supplier part numbers) by cross-reference type, either per organization or org-independent
-- Purpose: Column-selected read of MTL_CROSS_REFERENCES_B — auto-generated from field metadata
-- Grain  : One row per CROSS_REFERENCE_ID
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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.CROSS_REFERENCE_ID AS "Surrogate key of the cross-reference (added by the R12.1 restructure)",
  t.INVENTORY_ITEM_ID AS "The item the external identifier maps to",
  t.ORGANIZATION_ID AS "Inventory organization — NULL for org-independent references, so don't blanket-filter on it",
  t.CROSS_REFERENCE_TYPE AS "The cross-reference type (GTIN, old part number, customer part number…)",
  t.CROSS_REFERENCE AS "The external identifier itself",
  t.ORG_INDEPENDENT_FLAG AS "Whether the reference applies across all orgs (ORGANIZATION_ID is NULL on those rows)",
  t.DESCRIPTION AS "Description — untranslated copy; translated on the TL companion",
  t.START_DATE_ACTIVE AS "Effectivity start date (new in the R12.1 restructure)",
  t.END_DATE_ACTIVE AS "Effectivity end date",
  t.EPC_GTIN_SERIAL AS "GTIN serial component for EPC-style references"
FROM <catalog>.<schema>.MTL_CROSS_REFERENCES_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CROSS_REFERENCE_ID;