VIEW: APPS.JAI_INV_RGCO_AEL_V

Source

View Text - Preformatted

SELECT 'RG Registers Consolidation' Event_Type , 7000 Application_Id , gjh.ledger_id Set_of_book_Id , rg.organization_id Inv_Org_Id , ood.organization_code Inv_Org_Code , ood.organization_name Inv_Org_Name , 'JAI INV RGCO' Trx_Class , 'RG Consolidation' Trx_Class_Name , rg.consolidation_id Trx_Hdr_Id , 'JAI_CMN_RG_CONSLDATIONS' 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 , gjl.je_header_id JE_Header_Id , gjl.je_line_num JE_Line_Num , gjh.currency_code Entered_Currency , gjl.entered_dr Entered_Debit , gjl.entered_cr Entered_Credit , gjl.accounted_dr Account_Debit , gjl.accounted_cr Account_Credit , gjl.code_combination_id Account_Id , gjl.effective_date Accounting_Date , gjh.currency_conversion_rate Currency_Conversion_Rate , gjh.currency_conversion_type Currency_Conversion_Type , gdct.user_conversion_type Currency_User_Conversion_Type , gjh.currency_conversion_date Currency_Conversion_Date , rg.payment_id_ref Payments_Id , pla.vendor_id Vendor_Id , po.vendor_name Authority , pla.vendor_site_id Vendor_Site_Id , pos.vendor_site_code Location , pla.tr6_number TR6_Challan_Number , pla.tr6_date TR6_Challan_Date , rg.location_id Location_Id , loc.description Location_Name , rg.consolidation_date Consolidation_Date , rg.creation_date Creation_Date , rg.created_by Created_By , rg.last_update_date Last_Update_Date , rg.last_updated_by Last_Updated_By , rg.last_update_login Last_Update_Login FROM gl_je_headers gjh , gl_je_lines gjl , gl_import_references gjr , jai_cmn_rg_consldations rg , jai_cmn_rg_pla_hdrs pla , gl_je_categories gjc , gl_je_sources gjs , gl_daily_conversion_types gdct , po_vendors po , ap_supplier_sites_all pos , org_organization_definitions ood , hr_locations loc WHERE gjh.je_header_id = gjl.je_header_id AND gjr.je_header_id = gjl.je_header_id AND gjr.je_line_num = gjl.je_line_num AND rg.payment_id_ref = pla.pla_id AND gjc.je_category_name = gjh.je_category AND gjs.je_source_name = gjh.je_source AND gdct.conversion_type = gjh.currency_conversion_type AND to_char(rg.consolidation_id) = gjr.reference_5 AND gjr.reference_6 = 'consolidation_id' AND gjr.reference_2 = 'India Localization Entry' AND gjr.reference_3 = 'JAINRGCO' AND gjc.je_category_name = 'Payments' AND gjs.je_source_name = 'Payables India' AND po.vendor_id = pla.vendor_id ANd pos.vendor_site_id = pla.vendor_site_id AND ood.organization_id = rg.organization_id AND loc.location_id = rg.location_id

View Text - HTML Formatted

SELECT 'RG REGISTERS CONSOLIDATION' EVENT_TYPE
, 7000 APPLICATION_ID
, GJH.LEDGER_ID SET_OF_BOOK_ID
, RG.ORGANIZATION_ID INV_ORG_ID
, OOD.ORGANIZATION_CODE INV_ORG_CODE
, OOD.ORGANIZATION_NAME INV_ORG_NAME
, 'JAI INV RGCO' TRX_CLASS
, 'RG CONSOLIDATION' TRX_CLASS_NAME
, RG.CONSOLIDATION_ID TRX_HDR_ID
, 'JAI_CMN_RG_CONSLDATIONS' 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
, GJL.JE_HEADER_ID JE_HEADER_ID
, GJL.JE_LINE_NUM JE_LINE_NUM
, GJH.CURRENCY_CODE ENTERED_CURRENCY
, GJL.ENTERED_DR ENTERED_DEBIT
, GJL.ENTERED_CR ENTERED_CREDIT
, GJL.ACCOUNTED_DR ACCOUNT_DEBIT
, GJL.ACCOUNTED_CR ACCOUNT_CREDIT
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GDCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, RG.PAYMENT_ID_REF PAYMENTS_ID
, PLA.VENDOR_ID VENDOR_ID
, PO.VENDOR_NAME AUTHORITY
, PLA.VENDOR_SITE_ID VENDOR_SITE_ID
, POS.VENDOR_SITE_CODE LOCATION
, PLA.TR6_NUMBER TR6_CHALLAN_NUMBER
, PLA.TR6_DATE TR6_CHALLAN_DATE
, RG.LOCATION_ID LOCATION_ID
, LOC.DESCRIPTION LOCATION_NAME
, RG.CONSOLIDATION_DATE CONSOLIDATION_DATE
, RG.CREATION_DATE CREATION_DATE
, RG.CREATED_BY CREATED_BY
, RG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RG.LAST_UPDATED_BY LAST_UPDATED_BY
, RG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_IMPORT_REFERENCES GJR
, JAI_CMN_RG_CONSLDATIONS RG
, JAI_CMN_RG_PLA_HDRS PLA
, GL_JE_CATEGORIES GJC
, GL_JE_SOURCES GJS
, GL_DAILY_CONVERSION_TYPES GDCT
, PO_VENDORS PO
, AP_SUPPLIER_SITES_ALL POS
, ORG_ORGANIZATION_DEFINITIONS OOD
, HR_LOCATIONS LOC
WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND RG.PAYMENT_ID_REF = PLA.PLA_ID
AND GJC.JE_CATEGORY_NAME = GJH.JE_CATEGORY
AND GJS.JE_SOURCE_NAME = GJH.JE_SOURCE
AND GDCT.CONVERSION_TYPE = GJH.CURRENCY_CONVERSION_TYPE
AND TO_CHAR(RG.CONSOLIDATION_ID) = GJR.REFERENCE_5
AND GJR.REFERENCE_6 = 'CONSOLIDATION_ID'
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'JAINRGCO'
AND GJC.JE_CATEGORY_NAME = 'PAYMENTS'
AND GJS.JE_SOURCE_NAME = 'PAYABLES INDIA'
AND PO.VENDOR_ID = PLA.VENDOR_ID
AND POS.VENDOR_SITE_ID = PLA.VENDOR_SITE_ID
AND OOD.ORGANIZATION_ID = RG.ORGANIZATION_ID
AND LOC.LOCATION_ID = RG.LOCATION_ID