View: JAI_AP_BOE_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of BOE
Implementation/DBA Data:	APPS.JAI_AP_BOE_AEL_V

View Text

SELECT 7000 APPLICATION_ID
, DECODE(GJC.USER_JE_CATEGORY_NAME
, 'BILL OF ENTRY INDIA'
, 'BOE WRITEOFF'
, 'BOE ROUNDING') EVENT_TYPE
, 'JAI_BOE_WRITEOFF' TRX_CLASS
, 'JAI BOE WRITEOFF' TRX_CLASS_NAME
, JCBH.BOE_ID TRX_HDR_ID
, 'JAI_CMN_BOE_HDRS' 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_CMN_BOE_HDRS ' SOURCE_TABLE
, JCBH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JCBH.LAST_UPDATED_BY LAST_UPDATED_BY
, JCBH.CREATION_DATE CREATION_DATE
, JCBH.CREATED_BY CREATED_BY
, JCBH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, GL1.MEANING GL_TRANSFER_STATUS_NAME
, JCBH.BOE_ID BOE_NUMBER
, JCBH.BOE_TYPE
, PV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, JCBA.AGENT_CODE
, JCBA.AGENT_NAME
, JCBH.VESSEL_NAME
, JL.DESCRIPTION PORT_TYPE
, JCBH.PORT_NAME
, JCBH.COUNTRY_CONSIGNMNT
, JCBH.COUNTRY_ORIGIN
, JCBH.BOL_DATE
, OOD.ORGANIZATION_NAME
, HL.DESCRIPTION LOCATION
FROM PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, JA_LOOKUPS JL
, ORG_ORGANIZATION_DEFINITIONS OOD
, HR_LOCATIONS_ALL HL
, GL_LOOKUPS GL1
, GL_DAILY_CONVERSION_TYPES GLCT
, JAI_CMN_BOE_AGENTS JCBA
, JAI_CMN_BOE_HDRS_ALL JCBH
, GL_JE_CATEGORIES GJC
, GL_JE_SOURCES GJS
, GL_IMPORT_REFERENCES GIR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
WHERE GL1.LOOKUP_CODE = 'Y'
AND GL1.LOOKUP_TYPE = 'YES/NO'
AND GLCT.CONVERSION_TYPE = GJH.CURRENCY_CONVERSION_TYPE
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND PV.VENDOR_ID = PVS.VENDOR_ID
AND PVS.VENDOR_SITE_ID = JCBH.VENDOR_SITE_ID
AND OOD.ORGANIZATION_ID = JCBH.ORGANIZATION_ID
AND HL.LOCATION_ID = JCBH.LOCATION_ID
AND JCBH.VENDOR_ID = PV.VENDOR_ID
AND JCBH.AGENT_ID = JCBA.AGENT_ID
AND JL.LOOKUP_TYPE = 'JAI_PORT_CODE'
AND JCBH.PORT_CODE = JL.LOOKUP_CODE
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 IN ('JAINIBOE'
, 'JAINBOEI')
AND ((GIR.REFERENCE_4 = 'JA_IN_BOE_WRITE_OFF'
AND GJS.JE_SOURCE_NAME = 'PAYABLES INDIA'
AND GJC.JE_CATEGORY_NAME = 'BILL OF ENTRY INDIA') OR (GIR.REFERENCE_4 = 'JA_IN_BOE_SYS_ROUNDING'
AND GJS.JE_SOURCE_NAME = 'PAYABLES'
AND GJC.JE_CATEGORY_NAME = 'BOE'))
AND GIR.REFERENCE_5 = TO_CHAR(JCBH.BOE_ID)
AND GIR.REFERENCE_6 = 'BOE_ID'

Columns