View: IGI_EXP_AR_INV_V

Product:	IGI - Public Sector Financials International
Description:	Displays all unposted receivable transactions awaiting exchange protocol approval.
Implementation/DBA Data:	APPS.IGI_EXP_AR_INV_V

View Text

SELECT R.ROWID ROW_ID
, R.CUSTOMER_TRX_ID
, R.TRX_NUMBER
, R.CUST_TRX_TYPE_ID
, R.TRX_DATE
, C.CUSTOMER_NAME
, R.BILL_TO_CUSTOMER_ID
, S.LOCATION
, R.BILL_TO_SITE_USE_ID
, SUM(L.EXTENDED_AMOUNT) AMOUNT
, F.USER_NAME
, R.CREATED_BY
, R.CREATION_DATE
, T.TYPE TRX_TYPE
, R.INVOICE_CURRENCY_CODE
FROM FND_USER F
, IGI_RA_CUSTOMER_TRX ICT
, RA_CUSTOMER_TRX R
, RA_CUSTOMER_TRX_LINES L
, RA_CUST_TRX_LINE_GL_DIST D
, RA_CUST_TRX_TYPES T
, RA_HCUSTOMERS C
, RA_SITE_USES S
WHERE R.BILL_TO_CUSTOMER_ID = C.CUSTOMER_ID
AND R.BILL_TO_SITE_USE_ID = S.SITE_USE_ID
AND R.CUSTOMER_TRX_ID = ICT.CUSTOMER_TRX_ID(+)
AND R.CUSTOMER_TRX_ID = L.CUSTOMER_TRX_ID AND L.CUSTOMER_TRX_LINE_ID = D.CUSTOMER_TRX_LINE_ID AND D.GL_POSTED_DATE IS NULL
AND R.CREATED_BY = F.USER_ID
AND ICT.DIAL_UNIT_ID IS NULL
AND R.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID
AND NVL(ICT.EXP_HOLD
, 'N') != 'Y'
AND R.COMPLETE_FLAG <> 'Y' GROUP BY R.CUSTOMER_TRX_ID
, R.TRX_NUMBER
, R.CUST_TRX_TYPE_ID
, R.TRX_DATE
, C.CUSTOMER_NAME
, R.BILL_TO_CUSTOMER_ID
, S.LOCATION
, R.BILL_TO_SITE_USE_ID
, F.USER_NAME
, R.CREATED_BY
, R.CREATION_DATE
, T.TYPE
, R.INVOICE_CURRENCY_CODE
, R.ROWID

Columns