RCV_SHIPMENT_HEADERS

-- ============================================================
-- Table  : RCV_SHIPMENT_HEADERS — Receipt and expected-receipt headers — one row per supplier ASN, receipt, in-transit shipment, or RMA return, 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 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.SHIPMENT_HEADER_ID AS "Surrogate key of the receipt/shipment header",
  t.RECEIPT_SOURCE_CODE AS "Source of the shipment — VENDOR, INVENTORY, TRANSFER ORDER, CUSTOMER (RMA), OUTSOURCER",
  t.RECEIPT_NUM AS "Receipt number for this header — ASN-only headers have none until goods arrive",
  t.SHIPMENT_NUM AS "Source-assigned shipment number (ASN, in-transit, or transfer order)",
  t.ASN_TYPE AS "ASN / ASBN advance notice, or STD plain receipt",
  t.VENDOR_ID AS "Supplier on the shipment",
  t.VENDOR_SITE_ID AS "Supplier site",
  t.ORGANIZATION_ID AS "The FROM (shipping) org of in-transit shipments — NOT the receiving org; deliberately unanchored",
  t.SHIP_TO_ORG_ID AS "The receiving inventory org where the receipt is created",
  t.SHIP_TO_LOCATION_ID AS "Receiving location",
  t.CUSTOMER_ID AS "Customer — RMA (customer-return) receipts only",
  t.EMPLOYEE_ID AS "Person who created the receiving transaction",
  t.BILL_OF_LADING AS "Bill of lading number",
  t.PACKING_SLIP AS "Packing slip number",
  t.SHIPPED_DATE AS "When the shipment was created/shipped",
  t.EXPECTED_RECEIPT_DATE AS "Expected arrival date"
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>'  -- the column incremental BICC extracts key on
ORDER BY t.SHIPMENT_HEADER_ID;