View: AR_XML_INVOICE_LINE_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_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.INVENTORY_ITEM_ID
, NULL
, M.NAME
, FA_RX_FLEX_PKG.GET_VALUE(401
, 'MSTK'
, NULL
, 'ALL'
, L.INVENTORY_ITEM_ID)) ITEM
, DECODE(L.INVENTORY_ITEM_ID
, NULL
, M.DESCRIPTION
, I.DESCRIPTION) ITEM_DESCRIPTION
, ':'|| TO_CHAR(L.CUSTOMER_TRX_ID) ||':'|| TO_CHAR(L.CUSTOMER_TRX_LINE_ID) REFERENCE_NUMBER
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION1(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION2(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION3(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION4(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION5(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER5
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION6(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER6
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION7(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER7
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION8(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER8
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION9(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER9
, AR_XML_VIEW_FUNCTIONS.LINE_FUNCTION10(L.CUSTOMER_TRX_ID
, L.CUSTOMER_TRX_LINE_ID) USER10
FROM RA_CUSTOMER_TRX_LINES L
, MTL_SYSTEM_ITEMS I
, AR_MEMO_LINES_VL M
, OE_SYSTEM_PARAMETERS O
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 NVL(I.ORGANIZATION_ID
, O.MASTER_ORGANIZATION_ID) = O.MASTER_ORGANIZATION_ID
AND L.MEMO_LINE_ID = M.MEMO_LINE_ID(+) ORDER BY L.LINE_NUMBER

Columns