eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIL_FCTV_ORDERS

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Quantitative information related to customer sales orders
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
HEADER_ID
LINE_ID
ORDER_NUMBER
LINE_NUMBER
CUSTOMER_ID
ORG_ID
SHIP_TO_SITE_USE_ID
INVOICE_TO_SITE_USE_ID
SALESREP_ID
SALES_CHANNEL_CODE
INVENTORY_ITEM_ID
CURRENCY_CODE
UNIT_CODE
DATE_ORDERED
PRICE_LIST_ID
OPENED_FLAG
BOOKED_FLAG
CANCELLED_FLAG
ORDERED_QUANTITY
CANCELLED_QUANTITY
INVOICED_QUANTITY
SHIPPED_QUANTITY
LIST_PRICE
SELLING_PRICE