RA_CUSTOMER_TRX_LINES_ALL

-- ============================================================
-- Table  : RA_CUSTOMER_TRX_LINES_ALL — Receivables transaction lines — product lines, tax, and freight share the table by line type, with quantities, selling price, and the extended amount revenue analytics sum
-- Purpose: Column-selected read of RA_CUSTOMER_TRX_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + CUSTOMER_TRX_LINE_ID
-- Caution: LINE, TAX, and FREIGHT rows share this table — filter LINE_TYPE before summing or tax and freight inflate product revenue
-- 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.CUSTOMER_TRX_LINE_ID AS "Surrogate key of the line",
  t.CUSTOMER_TRX_ID AS "The parent transaction",
  t.ORG_ID AS "Operating unit",
  t.LINE_NUMBER AS "Line number within the document",
  t.LINE_TYPE AS "LINE, TAX, FREIGHT, or CHARGES (per the line-type lookup) — filter to LINE for product revenue",
  t.LINK_TO_CUST_TRX_LINE_ID AS "Ties tax and freight rows to their parent product line",
  t.INVENTORY_ITEM_ID AS "The invoiced item, when item-based",
  t.WAREHOUSE_ID AS "The ship-from inventory org — the org half of this table's item join",
  t.DESCRIPTION AS "Line description",
  t.QUANTITY_ORDERED AS "Quantity ordered",
  t.QUANTITY_INVOICED AS "Quantity invoiced",
  t.QUANTITY_CREDITED AS "Quantity credited by memos",
  t.UOM_CODE AS "UOM of the quantities",
  t.UNIT_SELLING_PRICE AS "Selling price per unit",
  t.EXTENDED_AMOUNT AS "The line amount — SUM only after filtering LINE_TYPE",
  t.REVENUE_AMOUNT AS "The revenue portion of the line",
  t.SALES_ORDER AS "The originating sales order number — TEXT, not an id; a display reference only",
  t.INTERFACE_LINE_CONTEXT AS "AutoInvoice line context — which attribute holds the order line id is source configuration; no reliable typed join exists"
FROM <catalog>.<schema>.RA_CUSTOMER_TRX_LINES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.CUSTOMER_TRX_LINE_ID = <CUSTOMER_TRX_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CUSTOMER_TRX_LINE_ID;