RCV_SHIPMENT_HEADERS

-- ============================================================
-- Table  : RCV_SHIPMENT_HEADERS — Receipt and expected-receipt headers — one row per supplier ASN, receipt, or internal shipment, grouped by receipt source; carries the receipt number, supplier, and expected/shipped dates
-- Purpose: Column-selected read of RCV_SHIPMENT_HEADERS — auto-generated from field metadata
-- Grain  : One row per SHIPMENT_HEADER_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.SHIPMENT_HEADER_ID AS "Surrogate key of the receipt/shipment header",
  t.RECEIPT_SOURCE_CODE AS "Where the receipt came from — supplier, internal order, or customer return; sources never mix under one header",
  t.RECEIPT_NUM AS "The receipt number — unique only within the receiving org, and NULL on ASN-only headers until goods arrive",
  t.SHIPMENT_NUM AS "The supplier's shipment/ASN number — supplier-assigned, not unique",
  t.SHIP_TO_ORG_ID AS "The receiving INVENTORY org — this table's org filter (not an operating unit)",
  t.VENDOR_ID AS "The supplier, for supplier-sourced receipts",
  t.VENDOR_SITE_ID AS "The supplier site",
  t.CUSTOMER_ID AS "The customer, for RMA (return) receipts",
  t.SHIPPED_DATE AS "When the source shipped",
  t.EXPECTED_RECEIPT_DATE AS "Expected arrival — the inbound-visibility date; the true receipt date lives on the RECEIVE transaction",
  t.BILL_OF_LADING AS "Bill of lading reference",
  t.PACKING_SLIP AS "Packing slip number",
  t.WAYBILL_AIRBILL_NUM AS "Carrier waybill/airbill number",
  t.FREIGHT_CARRIER_CODE AS "Freight carrier",
  t.ASN_TYPE AS "Ship notice kind — ASN vs ASBN (with billing)"
FROM <catalog>.<schema>.RCV_SHIPMENT_HEADERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.SHIPMENT_HEADER_ID = <SHIPMENT_HEADER_ID>
  -- AND t.EXPECTED_RECEIPT_DATE >= DATE '<DATE_FROM>'
  -- AND t.EXPECTED_RECEIPT_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.SHIPMENT_HEADER_ID;