VIEW: APPS.CLN_3C3_INVOICE_LINE_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)