View: AR_IDEP_ACTIONS_NOT_TAKEN

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

View Text

SELECT OL.COMMITMENT_ID COMMITMENT_ID
, TRX.TRX_NUMBER TRX_NUMBER
, OH.ORDER_NUMBER ORDER_NUMBER
, OL.PRICING_DATE TRX_DATE
, OTT.NAME TRX_TYPE
, OL.ORDERED_QUANTITY QTY
, OL.UNIT_SELLING_PRICE PRICE
, NVL ( ( OL.ORDERED_QUANTITY * OL.UNIT_SELLING_PRICE )
, 0 ) LINE_AMT
, NVL ( ( OL.ORDERED_QUANTITY * OL.UNIT_SELLING_PRICE )
, 0 ) EXT_AMT
, NVL ( OP.COMMITMENT_APPLIED_AMOUNT
, 0 ) APPLIED_AMOUNT
, NVL(AR_IDEP_UTILS.GET_COURSE_DESCRIPTION ( OL.LINE_ID
, OL.ORDER_QUANTITY_UOM )
, MT.DESCRIPTION) DESCRIPTION
FROM MTL_SYSTEM_ITEMS MT
, OE_PAYMENTS OP
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, OE_TRANSACTION_TYPES_TL OTT
, RA_CUSTOMER_TRX_ALL TRX
WHERE OL.HEADER_ID = OH.HEADER_ID
AND OH.ORDER_TYPE_ID = OTT.TRANSACTION_TYPE_ID
AND OH.ORG_ID = OL.ORG_ID
AND TRX.CUSTOMER_TRX_ID = OL.COMMITMENT_ID
AND NVL ( OL.CANCELLED_FLAG
, 'N') = 'N'
AND NVL ( OL.OPEN_FLAG
, 'Y') = 'Y'
AND ( ( NVL ( OL.INVOICE_INTERFACE_STATUS_CODE
, 'NO') <> 'YES' ) OR ( NVL ( OL.INVOICE_INTERFACE_STATUS_CODE
, 'NO') = 'YES'
AND EXISTS ( SELECT 1
FROM RA_INTERFACE_LINES_ALL L
, RA_CUSTOMER_TRX_LINES_ALL LINES
WHERE NVL ( L.INTERFACE_STATUS
, 'A') <> 'P'
AND L.SALES_ORDER = TO_CHAR ( OH.ORDER_NUMBER )
AND L.INTERFACE_LINE_ATTRIBUTE6 = OL.LINE_ID
AND LINES.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND L.REFERENCE_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID ) ) )
AND OP.HEADER_ID ( + ) = OL.HEADER_ID
AND OP.LINE_ID ( + ) = OL.LINE_ID
AND OL.INVENTORY_ITEM_ID=MT.INVENTORY_ITEM_ID(+)
AND MT.ORGANIZATION_ID = OL.ORG_ID

Columns