Product: | BIL - Sales Intelligence |
---|---|
Description: | Quantitative information related to customer sales orders |
Implementation/DBA Data: | Not implemented in this database |
SELECT HDR.HEADER_ID
, LINE.LINE_ID
, HDR.ORDER_NUMBER
, LINE.LINE_NUMBER
, HZCA.PARTY_ID
, NULL
, LINE. SHIP_TO_ORG_ID
, LINE.INVOICE_TO_ORG_ID
, JRS.RESOURCE_ID
, HDR.SALES_CHANNEL_CODE
, LINE.INVENTORY_ITEM_ID
, HDR.TRANSACTIONAL_CURR_CODE
, LINE.ORDER_QUANTITY_UOM
, HDR.ORDERED_DATE
, LINE.PRICE_LIST_ID
, HDR.OPEN_FLAG
, HDR.BOOKED_FLAG
, HDR.CANCELLED_FLAG
, LINE.ORDERED_QUANTITY
, LINE.CANCELLED_QUANTITY
, LINE.INVOICED_QUANTITY
, LINE.SHIPPED_QUANTITY
, LINE.UNIT_LIST_PRICE
, LINE.UNIT_SELLING_PRICE
FROM OE_ORDER_HEADERS HDR
, OE_ORDER_LINES LINE
, JTF_RS_SALESREPS JRS
, HZ_CUST_ACCOUNTS HZCA
WHERE HDR.HEADER_ID = LINE.HEADER_ID
AND JRS.SALESREP_ID = HDR.SALESREP_ID
AND HDR.SOLD_TO_ORG_ID = HZCA.CUST_ACCOUNT_ID
AND HZCA.STATUS IN ('I'
, 'A') WITH READ ONLY