View: AR_IDEP_ACTIONS_TAKEN

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_IDEP_ACTIONS_TAKEN

View Text

SELECT TRX.INITIAL_CUSTOMER_TRX_ID COMMITMENT_ID
, TRX.CUSTOMER_TRX_ID TRX_ID
, TRX.TRX_NUMBER TRX_NUMBER
, LINE.SALES_ORDER SALES_ORDER
, TRX.TRX_DATE TRX_DATE
, TYPE.TYPE CM_INV
, TYPE.NAME CHILD_TYPE
, NVL ( AR_IDEP_UTILS.GET_COURSE_DESCRIPTION ( LINE.INTERFACE_LINE_ATTRIBUTE6
, LINE.UOM_CODE )
, LINE.DESCRIPTION ) DESCRIPTION
, NVL ( LINE.QUANTITY_ORDERED
, LINE.QUANTITY_INVOICED ) QTY
, NVL ( LINE.UNIT_SELLING_PRICE
, LINE.UNIT_STANDARD_PRICE ) PRICE
, NVL ( LINE.EXTENDED_AMOUNT
, 0 ) LINE_AMT
, NVL ( LINE.EXTENDED_AMOUNT
, 0 ) EXT_AMT
, NVL ( TAXLINE.EXTENDED_AMOUNT
, 0 ) TAX_FREIGHT_AMT
, ( NVL ( LINE.EXTENDED_AMOUNT
, 0 ) + NVL ( TAXLINE.EXTENDED_AMOUNT
, 0 ) ) TOTAL_LINE_AMT
, LINE.LINE_NUMBER LINE_NUMBER
FROM RA_CUST_TRX_TYPES_ALL TYPE
, RA_CUSTOMER_TRX_LINES_ALL TAXLINE
, RA_CUSTOMER_TRX_LINES_ALL LINE
, RA_CUSTOMER_TRX_ALL TRX
WHERE TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID
AND TYPE.TYPE = 'INV'
AND COMPLETE_FLAG = 'Y'
AND LINE.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND LINE.LINE_TYPE = 'LINE'
AND TRX.ORG_ID = TYPE.ORG_ID
AND LINE.ORG_ID = TRX.ORG_ID
AND NVL(TAXLINE.LINE_TYPE
, 'TAX') = 'TAX'
AND TAXLINE.LINK_TO_CUST_TRX_LINE_ID(+) =LINE.CUSTOMER_TRX_LINE_ID
AND TAXLINE.ORG_ID(+) =LINE.ORG_ID UNION /* CREDIT MEMOS AGAINST COMMITMENT */ SELECT TRX.PREVIOUS_CUSTOMER_TRX_ID INITIAL_CUSTOMER_TRX_ID
, TRX.CUSTOMER_TRX_ID CHILD_CUSTOMER_TRX_ID
, TRX.TRX_NUMBER TRX_NUMBER
, LINE.SALES_ORDER SALES_ORDER
, TRX.TRX_DATE TRX_DATE
, TYPE.TYPE CM_INV
, TYPE.NAME CHILD_TYPE
, NVL ( AR_IDEP_UTILS.GET_COURSE_DESCRIPTION ( LINE.INTERFACE_LINE_ATTRIBUTE6
, LINE.UOM_CODE )
, LINE.DESCRIPTION ) DESCRIPTION
, NVL ( LINE.QUANTITY_ORDERED
, 0 ) QTY
, NVL ( LINE.UNIT_SELLING_PRICE
, 0 ) PRICE
, ( NVL ( LINE.EXTENDED_AMOUNT
, 0 ) ) LINE_AMT
, ( NVL ( LINE.EXTENDED_AMOUNT
, 0 ) ) EXT_AMT
, ( NVL ( TAXLINE.EXTENDED_AMOUNT
, 0 ) ) TAX_FREIGHT_AMT
, (( NVL ( LINE.EXTENDED_AMOUNT
, 0 ) ) + ( NVL( TAXLINE.EXTENDED_AMOUNT
, 0 ) ) ) TOTAL_LINE_AMT
, LINE.LINE_NUMBER LINE_NUMBER
FROM RA_CUST_TRX_TYPES_ALL TYPE
, RA_CUSTOMER_TRX_LINES_ALL TAXLINE
, RA_CUSTOMER_TRX_LINES_ALL LINE
, RA_CUSTOMER_TRX_ALL TRX
WHERE TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID
AND TYPE.TYPE = 'CM'
AND COMPLETE_FLAG = 'Y'
AND LINE.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND LINE.LINE_TYPE = 'LINE'
AND TRX.ORG_ID = TYPE.ORG_ID
AND LINE.ORG_ID = TRX.ORG_ID
AND NVL(TAXLINE.LINE_TYPE
, 'TAX') = 'TAX'
AND LINE.CUSTOMER_TRX_LINE_ID = TAXLINE.LINK_TO_CUST_TRX_LINE_ID ( + )
AND LINE.ORG_ID = TAXLINE.ORG_ID ( + ) UNION /* CREDIT MEMOS ON INVOICES AGAINST THE COMMITMENT */ SELECT TRX.INITIAL_CUSTOMER_TRX_ID INITIAL_CUSTOMER_TRX_ID
, TRX.CUSTOMER_TRX_ID CHILD_CM_CUST_TRX_ID
, TRX.TRX_NUMBER CHILD_TRX_NUMBER_CM
, LINE.SALES_ORDER SALES_ORDER
, TRX.TRX_DATE TRX_DATE_CM
, TYPE.TYPE CM_INV_CM
, TYPE.NAME CHILD_TYPE_CM
, LINE.DESCRIPTION DESCRIPTION
, NVL ( LINE.QUANTITY_ORDERED
, LINE.QUANTITY_INVOICED ) QTY
, NVL ( LINE.UNIT_SELLING_PRICE
, LINE.UNIT_STANDARD_PRICE ) PRICE
, NVL ( LINE.EXTENDED_AMOUNT
, 0 ) LINE_AMT
, NVL ( LINE.EXTENDED_AMOUNT
, 0 ) EXT_AMT
, NVL ( TAXLINE.EXTENDED_AMOUNT
, 0 ) TAX_FREIGHT_AMT
, ( NVL ( LINE.EXTENDED_AMOUNT
, 0 ) + NVL ( TAXLINE.EXTENDED_AMOUNT
, 0 ) ) TOTAL_LINE_AMT
, LINE.CUSTOMER_TRX_LINE_ID LINE_ID
FROM RA_CUSTOMER_TRX_ALL TRX
, RA_CUSTOMER_TRX_LINES_ALL TAXLINE
, RA_CUSTOMER_TRX_LINES_ALL LINE
, RA_CUST_TRX_TYPES_ALL TYPE
WHERE TRX.INITIAL_CUSTOMER_TRX_ID <> TRX.PREVIOUS_CUSTOMER_TRX_ID
AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID
AND TYPE.TYPE = 'CM'
AND COMPLETE_FLAG = 'Y'
AND LINE.LINE_TYPE = 'LINE'
AND LINE.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND NVL(TAXLINE.LINE_TYPE
, 'TAX') = 'TAX'
AND LINE.CUSTOMER_TRX_LINE_ID = TAXLINE.LINK_TO_CUST_TRX_LINE_ID ( + )
AND LINE.ORG_ID = TAXLINE.ORG_ID ( + )
AND TRX.ORG_ID = TYPE.ORG_ID

Columns