View: CLN_3C3_INVOICE_LINE_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of invoice lines which is used ot generate 3C3 outbound
Implementation/DBA Data:	APPS.CLN_3C3_INVOICE_LINE_V

View Text

SELECT L.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, L.LINE_TYPE LINE_TYPE
, L.LINE_NUMBER LINE_NUMBER
, L.EXTENDED_AMOUNT LINE_AMOUNT
, L.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, NVL(L.QUANTITY_INVOICED
, QUANTITY_CREDITED) QUANTITY
, L.DESCRIPTION DESCRIPTION
, L.UOM_CODE UOM
, DECODE(L.MEMO_LINE_ID
, NULL
, FA_RX_FLEX_PKG.GET_VALUE(401
, 'MSTK'
, NULL
, 'ALL'
, L.INVENTORY_ITEM_ID)
, M.NAME) ITEM
, DECODE(L.MEMO_LINE_ID
, NULL
, I.DESCRIPTION
, M.DESCRIPTION) ITEM_DESCRIPTION
, ':'|| TO_CHAR(L.CUSTOMER_TRX_ID) ||':'|| TO_CHAR(L.CUSTOMER_TRX_LINE_ID) REFERENCE_NUMBER
, L.SALES_ORDER SALES_ORDER_NUMBER
, NVL(L.SALES_ORDER_REVISION
, 0) SALES_ORDER_REVISION
, L.SALES_ORDER_LINE SALES_ORDER_LINE_NUMBER
FROM RA_CUSTOMER_TRX_LINES_ALL L
, MTL_SYSTEM_ITEMS I
, AR_MEMO_LINES_ALL_VL M
WHERE L.LINK_TO_CUST_TRX_LINE_ID IS NULL
AND L.LINE_TYPE = 'LINE'
AND L.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID(+)
AND I.ORGANIZATION_ID(+) = L.ORG_ID
AND NVL(M.ORG_ID
, L.ORG_ID) = L.ORG_ID
AND L.MEMO_LINE_ID = M.MEMO_LINE_ID(+)

Columns