View: IGI_EXP_DU_LINES_V

Product:	IGI - Public Sector Financials International
Description:	Returns details of all Payables and Receivables transactions that are included in Dialog Units.
Implementation/DBA Data:	APPS.IGI_EXP_DU_LINES_V

View Text

SELECT AR_TRANS.ROWID ROW_ID
, FAL.APPLICATION_NAME APPLICATION
, TRX.CTT_TYPE_NAME TRANSACTION_TYPE_DESC
, TRX.TRX_NUMBER TRANSACTION_NUMBER
, TRX.COMMENTS DESCRIPTION
, TRX.GD_GL_DATE GL_DATE
, TRX.RAC_BILL_TO_CUSTOMER_NAME THIRD_PARTY
, TRX.SU_BILL_TO_LOCATION THIRD_PARTY_SITE
, TRX_AMT.TRX_AMOUNT AMOUNT
, AR_TRANS.DU_ID DU_ID
, 222 APPLICATION_ID
, TRX.CTT_CLASS TRANSACTION_TYPE
, TRX.BILL_TO_CUSTOMER_ID THIRD_PARTY_ID
, TRX.BILL_TO_SITE_USE_ID THIRD_PARTY_SITE_ID
, TRX.INVOICE_CURRENCY_CODE CURRENCY_CODE
, AR_TRANS.ORG_ID ORG_ID
, AR_TRANS.CREATION_DATE CREATION_DATE
, AR_TRANS.CREATED_BY CREATED_BY
, AR_TRANS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AR_TRANS.LAST_UPDATED_BY LAST_UPDATED_BY
, AR_TRANS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AR_TRANS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AR_TRANS.ATTRIBUTE1 ATTRIBUTE1
, AR_TRANS.ATTRIBUTE2 ATTRIBUTE2
, AR_TRANS.ATTRIBUTE3 ATTRIBUTE3
, AR_TRANS.ATTRIBUTE4 ATTRIBUTE4
, AR_TRANS.ATTRIBUTE5 ATTRIBUTE5
, AR_TRANS.ATTRIBUTE6 ATTRIBUTE6
, AR_TRANS.ATTRIBUTE7 ATTRIBUTE7
, AR_TRANS.ATTRIBUTE8 ATTRIBUTE8
, AR_TRANS.ATTRIBUTE9 ATTRIBUTE9
, AR_TRANS.ATTRIBUTE10 ATTRIBUTE10
, AR_TRANS.ATTRIBUTE11 ATTRIBUTE11
, AR_TRANS.ATTRIBUTE12 ATTRIBUTE12
, AR_TRANS.ATTRIBUTE13 ATTRIBUTE13
, AR_TRANS.ATTRIBUTE14 ATTRIBUTE14
, AR_TRANS.ATTRIBUTE15 ATTRIBUTE15
, -999 AP_TRAN_ID
, -999 INVOICE_ID
, AR_TRANS.AR_TRAN_ID AR_TRAN_ID
, AR_TRANS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
FROM IGI_EXP_AR_TRANS AR_TRANS
, FND_APPLICATION_VL FAL
, RA_CUSTOMER_TRX_V TRX
, IGI_EXP_DUS DU
, IGI_EXP_AR_TRX_AMOUNTS_V TRX_AMT
WHERE AR_TRANS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND AR_TRANS.CUSTOMER_TRX_ID = TRX_AMT.CUSTOMER_TRX_ID
AND FAL.APPLICATION_ID = 222
AND AR_TRANS.DU_ID = DU.DU_ID UNION SELECT AP_TRANS.ROWID ROW_ID
, FAL.APPLICATION_NAME APPLICATION
, INV.INVOICE_TYPE TRANSACTION_TYPE_DESC
, INV.INVOICE_NUM TRANSACTION_NUMBER
, INV.DESCRIPTION DESCRIPTION
, INV.GL_DATE GL_DATE
, INV.VENDOR_NAME THIRD_PARTY
, INV.VENDOR_SITE_CODE THIRD_PARTY_SITE
, INV.INVOICE_AMOUNT AMOUNT
, AP_TRANS.DU_ID DU_ID
, 200 APPLICATION_ID
, INV.INVOICE_TYPE_LOOKUP_CODE TRANSACTION_TYPE
, INV.VENDOR_ID THIRD_PARTY_ID
, INV.VENDOR_SITE_ID THIRD_PARTY_SITE_ID
, INV.INVOICE_CURRENCY_CODE CURRENCY_CODE
, AP_TRANS.ORG_ID ORG_ID
, AP_TRANS.CREATION_DATE CREATION_DATE
, AP_TRANS.CREATED_BY CREATED_BY
, AP_TRANS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AP_TRANS.LAST_UPDATED_BY LAST_UPDATED_BY
, AP_TRANS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AP_TRANS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AP_TRANS.ATTRIBUTE1 ATTRIBUTE1
, AP_TRANS.ATTRIBUTE2 ATTRIBUTE2
, AP_TRANS.ATTRIBUTE3 ATTRIBUTE3
, AP_TRANS.ATTRIBUTE4 ATTRIBUTE4
, AP_TRANS.ATTRIBUTE5 ATTRIBUTE5
, AP_TRANS.ATTRIBUTE6 ATTRIBUTE6
, AP_TRANS.ATTRIBUTE7 ATTRIBUTE7
, AP_TRANS.ATTRIBUTE8 ATTRIBUTE8
, AP_TRANS.ATTRIBUTE9 ATTRIBUTE9
, AP_TRANS.ATTRIBUTE10 ATTRIBUTE10
, AP_TRANS.ATTRIBUTE11 ATTRIBUTE11
, AP_TRANS.ATTRIBUTE12 ATTRIBUTE12
, AP_TRANS.ATTRIBUTE13 ATTRIBUTE13
, AP_TRANS.ATTRIBUTE14 ATTRIBUTE14
, AP_TRANS.ATTRIBUTE15 ATTRIBUTE15
, AP_TRANS.AP_TRAN_ID AP_TRAN_ID
, AP_TRANS.INVOICE_ID INVOICE_ID
, -999 AR_TRAN_ID
, -999 CUSTOMER_TRX_ID
FROM IGI_EXP_AP_TRANS AP_TRANS
, FND_APPLICATION_VL FAL
, AP_INVOICES_V INV
, IGI_EXP_DUS DU
WHERE AP_TRANS.INVOICE_ID = INV.INVOICE_ID
AND FAL.APPLICATION_ID = 200
AND AP_TRANS.DU_ID = DU.DU_ID

Columns