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: XNC_ORDER_LINES_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	This view gives Order Line Details for an Order.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AIOV.HEADER_ID
, AIOV.LINE_ID
, AIOV.LINE_NUMBER
, OLT.NAME ACTION
, AIOV.INVENTORY_ITEM_ID
, AIOV.ORG_ID
, MTS.PADDED_CONCATENATED_SEGMENTS ITEM_NAME
, MTS.DESCRIPTION ITEM_DESC
, DECODE(XTV.ITEM_TYPE
, 'NON-RECURRING'
, (AIOV.UNIT_SELLING_PRICE * AIOV.ORDERED_QUANTITY )) ONE_TIME
, DECODE(XTV.ITEM_TYPE
, 'RECURRING'
, (AIOV.UNIT_SELLING_PRICE * AIOV.ORDERED_QUANTITY )) RECURRING
, AIOV.ORDER_QUANTITY_UOM UOM
, AIOV.ORDERED_QUANTITY QTY
, NULL SDN
, OL.MEANING STATUS
FROM ASO_I_OE_ORDER_LINES_V AIOV
, MTL_SYSTEM_ITEMS_VL MTS
, XNC_ITEM_TYPE_V XTV
, OE_LINE_TYPES_V OLT
, OE_LOOKUPS OL
WHERE AIOV.ORDERED_ITEM_ID = MTS.INVENTORY_ITEM_ID (+)
AND AIOV.INVENTORY_ITEM_ID = XTV.INVENTORY_ITEM_ID (+)
AND AIOV.ORG_ID = XTV.ORGANIZATION_ID (+)
AND AIOV.LINE_TYPE_ID = OLT.LINE_TYPE_ID (+)
AND AIOV.ORG_ID = MTS.ORGANIZATION_ID (+)
AND AIOV.FLOW_STATUS_CODE = OL.LOOKUP_CODE
AND OL.LOOKUP_TYPE='LINE_FLOW_STATUS'

Columns

Name
HEADER_ID
LINE_ID
LINE_NUMBER
ACTION
INVENTORY_ITEM_ID
ORG_ID
ITEM_NAME
ITEM_DESC
ONE_TIME
RECURRING
UOM
QTY
SDN
STATUS