View: JAI_AR_TRX_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of OFI AR transaction
Implementation/DBA Data:	APPS.JAI_AR_TRX_AEL_V

View Text

SELECT 7000 APPLICATION_ID
, 'COMPLETE THE AR TRANSACTION' EVENT_TYPE
, 'JAI AR TRX' TRX_CLASS
, 'JAI AR TRX' TRX_CLASS_NAME
, JAT.CUSTOMER_TRX_ID TRX_HDR_ID
, 'JAI_AR_TRXS' TRX_HDR_TABLE
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJH.LEDGER_ID
, GJH.JE_BATCH_ID
, GJL.JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE CURRENCY_CODE
, GJL.ENTERED_CR ENTERED_CR
, GJL.ENTERED_DR ENTERED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GLCT.USER_CONVERSION_TYPE
, 'JAI_AR_TRXS' SOURCE_TABLE
, JAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAT.LAST_UPDATED_BY LAST_UPDATED_BY
, JAT.CREATION_DATE CREATION_DATE
, JAT.CREATED_BY CREATED_BY
, JAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, L1.MEANING GL_TRANSFER_STATUS_NAME
, RCTA.TRX_DATE
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, JAT.VAT_INVOICE_NO
, SU_BILL.LOCATION CUST_SHIP_TO
, SU_BILL.LOCATION CUST_BILL_TO
, RCTA.TRX_NUMBER
, PBS.NAME SOURCE_NAME
, RCTYA.NAME TRANSACTION_TYPE_NAME
, JAT.ORGANIZATION_ID
, JAT.LOCATION_ID
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, RA_CUSTOMER_TRX_ALL RCTA
, RA_CUST_TRX_TYPES_ALL RCTYA
, RA_BATCH_SOURCES_ALL PBS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, JAI_AR_TRXS JAT
, AR_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, HZ_CUST_SITE_USES_ALL SU_BILL
, GL_IMPORT_REFERENCES GIR
WHERE L1.LOOKUP_CODE = 'Y'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RCTA.CUST_TRX_TYPE_ID = RCTYA.CUST_TRX_TYPE_ID
AND RCTA.ORG_ID = RCTYA.ORG_ID
AND RCTA.BATCH_SOURCE_ID = PBS.BATCH_SOURCE_ID
AND RCTA.ORG_ID = PBS.ORG_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.CUSTOMER_TRX_ID = JAT.CUSTOMER_TRX_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GIR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GIR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GIR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GIR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GIR.REFERENCE_3 = 'ACCT_INCLU_TAXES'
AND GIR.REFERENCE_4 = 'RA_CUSTOMER_TRX_ALL'
AND GIR.REFERENCE_5 = 'CUSTOMER_TRX_ID'
AND GIR.REFERENCE_6 = TO_CHAR(JAT.CUSTOMER_TRX_ID)
AND RCTA.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND RCTA.SHIP_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.JE_CATEGORY = 'REGISTER INDIA'
AND GJH.JE_SOURCE = 'RECEIVABLES INDIA' UNION ALL SELECT 7000 APPLICATION_ID
, 'VAT ACCOUNTING FOR MANUAL AR TRANSACTIONS' EVENT_TYPE
, 'JAI AR TRX' TRX_CLASS
, 'JAI AR TRX' TRX_CLASS_NAME
, JAT.CUSTOMER_TRX_ID TRX_HDR_ID
, 'JAI_AR_TRXS' TRX_HDR_TABLE
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJH.LEDGER_ID
, GJH.JE_BATCH_ID
, GJL.JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE CURRENCY_CODE
, GJL.ENTERED_CR ENTERED_CR
, GJL.ENTERED_DR ENTERED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GLCT.USER_CONVERSION_TYPE
, 'RA_CUSTOMER_TRX_LINES_ALL' SOURCE_TABLE
, JAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAT.LAST_UPDATED_BY LAST_UPDATED_BY
, JAT.CREATION_DATE CREATION_DATE
, JAT.CREATED_BY CREATED_BY
, JAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, L1.MEANING GL_TRANSFER_STATUS_NAME
, RCTA.TRX_DATE
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, JAT.VAT_INVOICE_NO
, SU_BILL.LOCATION CUST_SHIP_TO
, SU_BILL.LOCATION CUST_BILL_TO
, RCTA.TRX_NUMBER
, PBS.NAME SOURCE_NAME
, RCTYA.NAME TRANSACTION_TYPE_NAME
, JAT.ORGANIZATION_ID
, JAT.LOCATION_ID
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, RA_CUSTOMER_TRX_ALL RCTA
, JAI_AR_TRX_TAX_LINES RCTLA
, RA_CUST_TRX_TYPES_ALL RCTYA
, RA_BATCH_SOURCES_ALL PBS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, JAI_AR_TRXS JAT
, JAI_AR_TRX_LINES JATL
, AR_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, HZ_CUST_SITE_USES_ALL SU_BILL
, GL_IMPORT_REFERENCES GIR
WHERE L1.LOOKUP_CODE = 'Y'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RCTA.CUST_TRX_TYPE_ID = RCTYA.CUST_TRX_TYPE_ID
AND RCTA.ORG_ID = RCTYA.ORG_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND JAT.CUSTOMER_TRX_ID = JATL.CUSTOMER_TRX_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GIR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GIR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GIR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GIR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GIR.REFERENCE_3 = 'JAI_RGM_OM_AR_VAT_ACCOUNTING.PROCESS_ORDER_INVOICE'
AND GIR.REFERENCE_4 = 'CUSTOMER_TRX_LINE_ALL'
AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(GIR.REFERENCE_5
, '0123456789'
, ''))
, NULL
, GIR.REFERENCE_5
, -99999)) = RCTLA.CUSTOMER_TRX_LINE_ID
AND GIR.REFERENCE_6 = 'JAI_RGM_TRX_RECORDS'
AND JATL.CUSTOMER_TRX_LINE_ID = RCTLA.LINK_TO_CUST_TRX_LINE_ID
AND RCTA.CUSTOMER_TRX_ID = JAT.CUSTOMER_TRX_ID
AND RCTA.SHIP_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND RCTA.SHIP_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND RCTA.BATCH_SOURCE_ID = PBS.BATCH_SOURCE_ID
AND RCTA.ORG_ID = PBS.ORG_ID
AND GJH.JE_CATEGORY = 'REGISTER INDIA'
AND GJH.JE_SOURCE = 'VAT INDIA' UNION ALL SELECT 7000 APPLICATION_ID
, 'COMPLETE THE AR TRANSACTION' EVENT_TYPE
, 'JAI AR TRX' TRX_CLASS
, 'JAI AR TRX' TRX_CLASS_NAME
, JAT.CUSTOMER_TRX_ID TRX_HDR_ID
, 'JAI_AR_TRXS' TRX_HDR_TABLE
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJH.LEDGER_ID
, GJH.JE_BATCH_ID
, GJL.JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE CURRENCY_CODE
, GJL.ENTERED_CR ENTERED_CR
, GJL.ENTERED_DR ENTERED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GLCT.USER_CONVERSION_TYPE
, 'JAI_AR_TRXS' SOURCE_TABLE
, JAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAT.LAST_UPDATED_BY LAST_UPDATED_BY
, JAT.CREATION_DATE CREATION_DATE
, JAT.CREATED_BY CREATED_BY
, JAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, L1.MEANING GL_TRANSFER_STATUS_NAME
, RCTA.TRX_DATE
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, JAT.VAT_INVOICE_NO
, SU_BILL.LOCATION CUST_SHIP_TO
, SU_BILL.LOCATION CUST_BILL_TO
, RCTA.TRX_NUMBER
, PBS.NAME SOURCE_NAME
, RCTYA.NAME TRANSACTION_TYPE_NAME
, JAT.ORGANIZATION_ID
, JAT.LOCATION_ID
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, RA_CUSTOMER_TRX_ALL RCTA
, RA_CUST_TRX_TYPES_ALL RCTYA
, RA_BATCH_SOURCES_ALL PBS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, JAI_AR_TRXS JAT
, AR_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_CATEGORIES GJC
, HZ_CUST_SITE_USES_ALL SU_BILL
, GL_JE_SOURCES GJS
, GL_IMPORT_REFERENCES GIR
WHERE L1.LOOKUP_CODE = 'Y'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RCTA.CUST_TRX_TYPE_ID = RCTYA.CUST_TRX_TYPE_ID
AND RCTA.ORG_ID = RCTYA.ORG_ID
AND RCTA.BATCH_SOURCE_ID = PBS.BATCH_SOURCE_ID
AND RCTA.ORG_ID = PBS.ORG_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.CUSTOMER_TRX_ID = JAT.CUSTOMER_TRX_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GIR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GIR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GIR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GIR.REFERENCE_3 = 'JAI_AR_TCS_REP_PKG.AR_ACCOUNTING'
AND GIR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GIR.REFERENCE_4 = 'RA_CUSTOMER_TRX_ALL'
AND GIR.REFERENCE_6 = 'CUSTOMER_TRX_ID'
AND GIR.REFERENCE_5 = TO_CHAR(JAT.CUSTOMER_TRX_ID)
AND RCTA.SHIP_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND RCTA.SHIP_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJC.JE_CATEGORY_NAME = 'INDIA TAX COLLECTED'
AND GJS.JE_SOURCE_NAME = 'RECEIVABLES INDIA' UNION ALL SELECT 7000 APPLICATION_ID
, 'ST ACCOUNTING IN INVOICE
AND RECEIPT APPLICATION' EVENT_TYPE
, 'JAI AR TRX' TRX_CLASS
, 'JAI AR TRX' TRX_CLASS_NAME
, JAT.CUSTOMER_TRX_ID TRX_HDR_ID
, 'JAI_AR_TRXS' TRX_HDR_TABLE
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJH.LEDGER_ID
, GJH.JE_BATCH_ID
, GJL.JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE CURRENCY_CODE
, GJL.ENTERED_CR ENTERED_CR
, GJL.ENTERED_DR ENTERED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GLCT.USER_CONVERSION_TYPE
, 'AR_RECEIVABLE_APPLICATIONS_ALL' SOURCE_TABLE
, JAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAT.LAST_UPDATED_BY LAST_UPDATED_BY
, JAT.CREATION_DATE CREATION_DATE
, JAT.CREATED_BY CREATED_BY
, JAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, L1.MEANING GL_TRANSFER_STATUS_NAME
, RCTA.TRX_DATE
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, JAT.VAT_INVOICE_NO
, SU_SHIP.LOCATION CUST_SHIP_TO
, SU_SHIP.LOCATION CUST_BILL_TO
, RCTA.TRX_NUMBER
, PBS.NAME SOURCE_NAME
, RCTYA.NAME TRANSACTION_TYPE_NAME
, JAT.ORGANIZATION_ID
, JAT.LOCATION_ID
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, RA_CUSTOMER_TRX_ALL RCTA
, AR_RECEIVABLE_APPLICATIONS_ALL REC_APP
, RA_CUST_TRX_TYPES_ALL RCTYA
, RA_BATCH_SOURCES_ALL PBS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, JAI_AR_TRXS JAT
, AR_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, HZ_CUST_SITE_USES_ALL SU_SHIP
, GL_IMPORT_REFERENCES GIR
WHERE L1.LOOKUP_CODE = 'Y'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RCTA.CUST_TRX_TYPE_ID = RCTYA.CUST_TRX_TYPE_ID
AND RCTA.ORG_ID = RCTYA.ORG_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.CUSTOMER_TRX_ID = JAT.CUSTOMER_TRX_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GIR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GIR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GIR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND JAT.CUSTOMER_TRX_ID = REC_APP.APPLIED_CUSTOMER_TRX_ID
AND RCTA.SHIP_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.BILL_TO_SITE_USE_ID = SU_SHIP.SITE_USE_ID(+)
AND RCTA.SHIP_TO_SITE_USE_ID = SU_SHIP.SITE_USE_ID(+)
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND RCTA.BATCH_SOURCE_ID = PBS.BATCH_SOURCE_ID
AND RCTA.ORG_ID = PBS.ORG_ID
AND GIR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GIR.REFERENCE_4 = 'AR_RECEIVABLE_APPLICATIONS_ALL'
AND GIR.REFERENCE_5 = TO_CHAR(REC_APP.RECEIVABLE_APPLICATION_ID)
AND GJH.JE_CATEGORY = 'REGISTER INDIA'
AND GJH.JE_SOURCE = 'SERVICE TAX INDIA' UNION ALL SELECT 7000 APPLICATION_ID
, 'COMPLETE THE AR TRANSACTION' EVENT_TYPE
, 'JAI AR TRX' TRX_CLASS
, 'JAI AR TRX' TRX_CLASS_NAME
, JAT.CUSTOMER_TRX_ID TRX_HDR_ID
, 'JAI_AR_TRXS' TRX_HDR_TABLE
, GJH.JE_CATEGORY JE_CATEGORY
, GJC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, GJH.JE_SOURCE JE_SOURCE
, GJS.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, GJH.LEDGER_ID
, GJH.JE_BATCH_ID
, GJL.JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE CURRENCY_CODE
, GJL.ENTERED_CR ENTERED_CR
, GJL.ENTERED_DR ENTERED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GLCT.USER_CONVERSION_TYPE
, 'JAI_AR_TRXS' SOURCE_TABLE
, JAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JAT.LAST_UPDATED_BY LAST_UPDATED_BY
, JAT.CREATION_DATE CREATION_DATE
, JAT.CREATED_BY CREATED_BY
, JAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, L1.MEANING GL_TRANSFER_STATUS_NAME
, RCTA.TRX_DATE
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, JAT.VAT_INVOICE_NO
, SU_BILL.LOCATION CUST_SHIP_TO
, SU_BILL.LOCATION CUST_BILL_TO
, RCTA.TRX_NUMBER
, PBS.NAME SOURCE_NAME
, RCTYA.NAME TRANSACTION_TYPE_NAME
, JAT.ORGANIZATION_ID
, JAT.LOCATION_ID
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, RA_CUSTOMER_TRX_ALL RCTA
, RA_CUSTOMER_TRX_LINES_ALL RCTLA
, RA_CUST_TRX_TYPES_ALL RCTYA
, RA_BATCH_SOURCES_ALL PBS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, JAI_AR_TRXS JAT
, AR_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, HZ_CUST_SITE_USES_ALL SU_BILL
, GL_IMPORT_REFERENCES GIR
WHERE L1.LOOKUP_CODE = 'Y'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RCTA.CUST_TRX_TYPE_ID = RCTYA.CUST_TRX_TYPE_ID
AND RCTA.ORG_ID = RCTYA.ORG_ID
AND RCTA.BATCH_SOURCE_ID = PBS.BATCH_SOURCE_ID
AND RCTA.ORG_ID = PBS.ORG_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND RCTA.BILL_TO_CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND RCTA.CUSTOMER_TRX_ID = JAT.CUSTOMER_TRX_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GIR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GIR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GIR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GIR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GIR.REFERENCE_3 = 'JA_IN_AR_HDR_COMPLETE_TRG'
AND GIR.REFERENCE_4 = 'RA_CUSTOMER_TRX_LINES_ALL'
AND GIR.REFERENCE_5 = TO_CHAR(RCTLA.CUSTOMER_TRX_LINE_ID)
AND GIR.REFERENCE_6 = 'CUSTOMER_TRX_LINE_ID'
AND RCTA.CUSTOMER_TRX_ID = RCTLA.CUSTOMER_TRX_ID
AND RCTA.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND RCTA.SHIP_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.JE_CATEGORY = 'REGISTER INDIA'
AND GJH.JE_SOURCE = 'RECEIVABLES INDIA'

Columns