VIEW: APPS.IGI_EXP_DU_LINES_V

Source

View Text - Preformatted

SELECT AR_TRANS.ROWID ROW_ID , FAL.APPLICATION_NAME APPLICATION , TRX.CTT_TYPE_NAME TRANSACTION_TYPE_DESC , TRX.TRX_NUMBER TRANSACTION_NUMBER , '' 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_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 is Not NULL 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 WHERE AP_TRANS.INVOICE_ID = INV.INVOICE_ID AND FAL.APPLICATION_ID = 200 AND AP_TRANS.DU_ID IS NOT NULL

View Text - HTML Formatted

SELECT AR_TRANS.ROWID ROW_ID
, FAL.APPLICATION_NAME APPLICATION
, TRX.CTT_TYPE_NAME TRANSACTION_TYPE_DESC
, TRX.TRX_NUMBER TRANSACTION_NUMBER
, '' 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_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 IS NOT NULL 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
WHERE AP_TRANS.INVOICE_ID = INV.INVOICE_ID
AND FAL.APPLICATION_ID = 200
AND AP_TRANS.DU_ID IS NOT NULL