eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JAI_AR_TRX_AEL_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'