View: JAI_INV_RG1_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_INV_RG1_AEL_V

View Text

SELECT 'RG-1 ENTRY' EVENT_TYPE
, 7000 APPLICATION_ID
, GJH.LEDGER_ID SET_OF_BOOK_ID
, RG.ORGANIZATION_ID INV_ORG_ID
, INV_OOD.ORGANIZATION_CODE INV_ORG_CODE
, 'JAI INV RG1' TRX_CLASS
, 'RG1 REGISTER ENTRY' TRX_CLASS_NAME
, RG.REGISTER_ID_PART_II TRX_HDR_ID
, 'JAI_CMN_RG_I_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
, 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.EXCISE_INVOICE_NUMBER INVOICE_NUMBER
, RG.SLNO SERIAL_NUMBER
, RG.INVENTORY_ITEM_ID ITEM_ID
, RG.TRANSACTION_UOM_CODE UOM
, DECODE(RG.ISSUE_TYPE
, 'HU'
, NVL(RG.FOR_HOME_USE_PAY_ED_QTY
, 0)
, 'EWE'
, NVL(RG.FOR_EXPORT_PAY_ED_QTY
, 0)
, 'ENE'
, NVL(RG.FOR_EXPORT_N_PAY_ED_QTY
, 0)
, 'OF'
, NVL(RG.TO_OTHER_FACTORY_N_PAY_ED_QTY
, 0)
, 'OPWE'
, NVL(RG.OTHER_PURPOSE_PAY_ED_QTY
, 0)
, 'OPNE'
, NVL(RG.OTHER_PURPOSE_N_PAY_ED_QTY
, 0)
, NULL) QUANTITY
, DECODE(RG.TRANSACTION_TYPE
, 'R'
, 'VENDOR'
, 'I'
, 'CUSTOMER'
, 'CR'
, 'CUSTOMER'
, 'IOR'
, 'ORGANIZATION'
, 'IOI'
, 'ORGANIZATION'
, NULL) PARTY_TYPE
, NVL(RG.CUSTOMER_ID
, RG.VENDOR_ID) PARTY_ID
, DECODE(SIGN(RG.CUSTOMER_ID)
, 1
, HZP.PARTY_NUMBER
, -1
, CUS_OOD.ORGANIZATION_CODE
, NULL
, PO.SEGMENT1) PARTY_NUMBER
, DECODE(SIGN(RG.CUSTOMER_ID)
, 1
, HZP.PARTY_NAME
, -1
, CUS_OOD.ORGANIZATION_NAME
, NULL
, PO.VENDOR_NAME) PARTY_NAME
, NVL(RG.CUSTOMER_SITE_ID
, RG.VENDOR_SITE_ID) PARTY_SITE_ID
, DECODE(SIGN(RG.CUSTOMER_ID)
, 1
, HZCS.LOCATION
, -1
, HLOC.LOCATION_CODE
, NULL
, POS.VENDOR_SITE_CODE) PARTY_SITE_NAME
, RG.PAYMENT_REGISTER PAYMENT_REGISTER
, DECODE(RG.ISSUE_TYPE
, 'HU'
, 'HOME USE'
, 'EWE'
, 'EXPORT WITH EXCISE'
, 'ENE'
, 'EXPORT WITHOUT EXCISE'
, 'OF'
, 'OTHER FACTORY'
, 'OPWE'
, 'OTHER PURPOSE WITH EXCISE'
, 'OPNE'
, 'OTHER PURPOSE WITHOUT EXCISE'
, NULL) ISSUE_TYPE
, RG.EXCISE_INVOICE_DATE INVOICE_DATE
, RG.REF_DOC_NO REFERENCE_NUMBER
, DECODE(RG.TRANSACTION_TYPE
, 'I'
, 'ISSUE'
, 'R'
, 'RECEIPT'
, 'IOR'
, 'INTER.ORG.RECEIPT'
, 'IOI'
, 'INTER.ORG.ISSUE'
, 'IA'
, 'ISSUE ADJUSTMENT'
, 'RA'
, 'RECEIPT ADJUSTMENT'
, 'PI'
, 'PRODUCTION ISSUE'
, 'PR'
, 'PRODUCTION RECEIPT'
, 'CR'
, 'CUSTOMER RETURN'
, NULL) TRANSACTION_TYPE
, RG.TRANSACTION_DATE TRANSACTION_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_I_TRXS RG
, GL_JE_CATEGORIES GJC
, GL_JE_SOURCES GJS
, GL_DAILY_CONVERSION_TYPES GDCT
, ORG_ORGANIZATION_DEFINITIONS INV_OOD
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, HZ_CUST_SITE_USES_ALL HZCS
, ORG_ORGANIZATION_DEFINITIONS CUS_OOD
, HR_LOCATIONS HLOC
, PO_VENDORS PO
, AP_SUPPLIER_SITES_ALL POS
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 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.REGISTER_ID_PART_II) = GJR.REFERENCE_5
AND GJR.REFERENCE_6 = 'REGISTER_ID'
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'JAINIRGI.RG_I.POST_INSERT'
AND GJC.JE_CATEGORY_NAME = 'REGISTER INDIA'
AND GJS.JE_SOURCE_NAME = 'REGISTER INDIA'
AND INV_OOD.ORGANIZATION_ID = RG.ORGANIZATION_ID
AND HZP.PARTY_ID(+) = HZCA.PARTY_ID
AND HZCA.CUST_ACCOUNT_ID(+) = RG.CUSTOMER_ID
AND HZCS.SITE_USE_ID(+) = RG.CUSTOMER_SITE_ID
AND CUS_OOD.ORGANIZATION_ID(+) = -RG.CUSTOMER_ID
AND HLOC.LOCATION_ID(+) = -RG.CUSTOMER_SITE_ID
AND PO.VENDOR_ID(+) = RG.VENDOR_ID
AND POS.VENDOR_SITE_ID(+) = RG.VENDOR_SITE_ID

Columns