View: JAI_INV_RGCO_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of RG consolidation
Implementation/DBA Data:	APPS.JAI_INV_RGCO_AEL_V

View Text

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

Columns