View: JAI_PLA_ENTRY_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of PLA entry
Implementation/DBA Data:	APPS.JAI_PLA_ENTRY_AEL_V

View Text

SELECT 7000 APPLICATION_ID
, 'PLA MANUAL ENTRY' EVENT_TYPE
, 'JAI PLA REGISTER' TRX_CLASS
, 'JAI PLA REGISTER' TRX_CLASS_NAME
, PLA.REGISTER_ID TRX_HDR_ID
, 'JAI_CMN_RG_PLA_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_DR ENTERED_CR
, GJL.ENTERED_CR 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 CURRENCY_USER_CONVERSION_TYPE
, PLA.REGISTER_ID SOURCE_ID
, 'JAI_CMN_RG_PLA_TRXS ' SOURCE_TABLE
, PLA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PLA.LAST_UPDATED_BY LAST_UPDATED_BY
, PLA.CREATION_DATE CREATION_DATE
, PLA.CREATED_BY CREATED_BY
, PLA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'Y' GL_TRANSFER_STATUS
, GL1.MEANING GL_TRANSFER_STATUS_NAME
, HOI.ORG_INFORMATION3 ORG_ID
, PLA.VENDOR_ID THIRD_PARTY_ID
, DECODE(PLA.VENDOR_CUST_FLAG
, 'V'
, (SELECT VENDOR_NAME
FROM PO_VENDORS
WHERE VENDOR_ID = PLA.VENDOR_ID)
, (SELECT HZP.PARTY_NAME
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
WHERE HZP.PARTY_ID = HZCA.PARTY_ID
AND HZCA.CUST_ACCOUNT_ID = PLA.VENDOR_ID)) THIRD_PARTY_NAME
, PLA.VENDOR_CUST_FLAG THIRD_PARTY_NUMBER
, PLA.VENDOR_SITE_ID THIRD_PARTY_SUB_ID
, DECODE(PLA.VENDOR_CUST_FLAG
, 'V'
, (SELECT VENDOR_SITE_CODE
FROM PO_VENDOR_SITES_ALL
WHERE VENDOR_ID = PLA.VENDOR_ID
AND VENDOR_SITE_ID = PLA.VENDOR_SITE_ID)
, (SELECT LOCATION
FROM HZ_CUST_SITE_USES_ALL
WHERE SITE_USE_ID = PLA.VENDOR_SITE_ID)) THIRD_PARTY_SUB_NAME
, PLA.TRANSACTION_DATE TRX_DATE
, PLA.REF_DOCUMENT_ID REFERENCE_NO
, NVL(PLA.DR_INVOICE_NO
, PLA.EXCISE_INVOICE_NO) INVOICE_NO
, PLA.DR_INVOICE_DATE INVOICE_DATE
, OOD.ORGANIZATION_NAME ORG_NAME
, PLA.INVENTORY_ITEM_ID ITEM_ID
, PLA.SLNO SERIAL_NO
, DECODE(PLA.CR_BASIC_ED
, NULL
, (DECODE(PLA.DR_BASIC_ED
, NULL
, NULL
, 'ISSUE'))
, 'RECEIPT') TRANSACTION_TYPE
, DECODE(PLA.ISSUE_TYPE
, 'DOMESTIC'
, 'DOMESTIC'
, 'EXPORT'
, 'EXPORT'
, NULL) ISSUE_TYPE
, HL.LOCATION_ID LOCATION_ID
, HL.DESCRIPTION LOCATION_NAME
, OOD.ORGANIZATION_CODE INVENTORY_ORGANIZATION_CODE
, PLA.ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
FROM GL_DAILY_CONVERSION_TYPES GLCT
, GL_LOOKUPS GL1
, HR_ORGANIZATION_INFORMATION HOI
, JAI_CMN_RG_PLA_TRXS PLA
, ORG_ORGANIZATION_DEFINITIONS OOD
, HR_LOCATIONS_ALL HL
, MTL_SYSTEM_ITEMS_B MSI
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_IMPORT_REFERENCES GIR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
WHERE GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GLCT.CONVERSION_TYPE = GJH.CURRENCY_CONVERSION_TYPE
AND GL1.LOOKUP_CODE = 'Y'
AND GL1.LOOKUP_TYPE = 'YES/NO'
AND HOI.ORGANIZATION_ID = PLA.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND OOD.ORGANIZATION_ID = PLA.ORGANIZATION_ID
AND PLA.LOCATION_ID = HL.LOCATION_ID
AND MSI.INVENTORY_ITEM_ID = PLA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = PLA.ORGANIZATION_ID
AND GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
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 = 'JAINPLAM.GL_INTERFACE_NEW'
AND GIR.REFERENCE_4 = 'JA_IN_PLA'
AND GIR.REFERENCE_5 = PLA.REGISTER_ID || ':' || PLA.SLNO
AND GIR.REFERENCE_6 = 'REGISTER_ID : SLNO'
AND GJS.JE_SOURCE_NAME = 'REGISTER INDIA'
AND GJC.JE_CATEGORY_NAME = 'REGISTER INDIA'

Columns