[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 |