eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: JAI_PO_REC_AEL_V

Product:	JA - Asia/Pacific Localizations
Description:	Base view of PO receipt
Implementation/DBA Data:	APPS.JAI_PO_REC_AEL_V

View Text

SELECT /*+ ORDERED USE_NL(JRH JRL) USE_NL(JRL JRT) USE_NL(JRT RSL) USE_NL(JRT JRRL) USE_NL(JRT GJR) USE_NL(GJR GJH) USE_NL(GJH GJL) USE_NL(GJH GJS) USE_NL(GJH GJC) USE_NL(GJH GLCT) INDEX(GJR GL_IMPORT_REFERENCES_N3) */ 7000 APPLICATION_ID
, 'PO RECEIPT' EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC' TRX_CLASS
, 'JAI PO REC' TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS' TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, NULL UOM
, JRT.QUANTITY QUANTITY
, NULL LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL (JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO) EXCISE_INV_NUM
, NVL (JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, NVL (JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO) VAT_INV_NUM
, NVL (JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE) VAT_INVOICE_DATE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, NULL PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM JAI_RCV_HEADERS JRH
, JAI_RCV_LINES JRL
, JAI_RCV_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_RGM_LINES JRRL
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RSL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRH.SHIPMENT_HEADER_ID = JRL.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+) = JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+) = JRT.SHIPMENT_LINE_ID
AND JRH.RECEIPT_SOURCE_CODE IN ('VENDOR'
, 'INTERNAL ORDER')
AND JRH.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND (GJR.REFERENCE_3 IN ('JAI_RCV_RCV_RTV_PKG.POST_ENTRIES'
, 'JAI_RCV_RCV_RTV_PKG.REGIME_TAX_ACCOUNTING_INTERIM'
, 'JAI_RCV_EXCISE_PROCESSING_PKG.ACCOUNTING_ENTRIES'
, 'JAI_RCV_DELIVER_RTR_PKG.DELIVER_RTR_RECO_NONEXCISE'
, 'JAI_RCV_DELIVER_RTR_PKG.EXPENSE_ACCOUNTING'
, 'JA_IN_RECEIVE_RTV_PKG.POST_ENTRIES'
, 'JA_IN_RECEIVE_RTV_PKG.REGIME_TAX_ACCOUNTING_INTERIM'
, 'JA_IN_RECEIPT_CENVAT_RG_PKG.ACCOUNTING_ENTRIES'
, 'JA_IN_DELIVER_RTR_PKG.DELIVER_RTR_RECO_NONEXCISE'
, 'JA_IN_DELIVER_RTR_PKG.EXPENSE_ACCOUNTING') OR GJR.REFERENCE_3 LIKE 'JAI_RCV_DELIVER_RTR_PKG.DELIVER_RTR_RECO_NONEXCISE%' OR GJR.REFERENCE_3 LIKE 'JA_IN_DELIVER_RTR_PKG.DELIVER_RTR_RECO_NONEXCISE%')
AND GJR.REFERENCE_4 = 'RCV_TRANSACTIONS'
AND GJR.REFERENCE_5 = TO_CHAR (JRT.TRANSACTION_ID)
AND GJR.REFERENCE_6 = 'TRANSACTION_ID'
AND GJS.JE_SOURCE_NAME IN ('PURCHASING'
, 'PURCHASING INDIA')
AND (GJC.JE_CATEGORY_NAME = 'RECEIVING INDIA' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'RECEIVING INDIA') UNION ALL SELECT /*+ ORDERED USE_NL(JRH JRL) USE_NL(JRL JRT) USE_NL(JRT RSL) USE_NL(JRT JRRL) USE_NL(JRT GJR) USE_NL(GJR GJH) USE_NL(GJH GJL) USE_NL(GJH GJS) USE_NL(GJH GJC) USE_NL(GJH GLCT) INDEX(GJR GL_IMPORT_REFERENCES_N3) */ 7000 APPLICATION_ID
, 'PO RECEIPT' EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC' TRX_CLASS
, 'JAI PO REC' TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS' TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, NULL UOM
, JRT.QUANTITY QUANTITY
, NULL LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL (JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO) EXCISE_INV_NUM
, NVL (JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, NVL (JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO) VAT_INV_NUM
, NVL (JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE) VAT_INVOICE_DATE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, NULL PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM JAI_RCV_HEADERS JRH
, JAI_RCV_LINES JRL
, JAI_RCV_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_RGM_LINES JRRL
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND RSL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRL.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+) = JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+) = JRT.SHIPMENT_LINE_ID
AND JRH.RECEIPT_SOURCE_CODE = 'CUSTOMER'
AND JRH.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 IN ('JAI_RGM_CLAIM_PKG.DO_RMA_ACCOUNTING'
, 'JAI_RCV_EXCISE_PROCESSING_PKG.ACCOUNTING_ENTRIES')
AND GJR.REFERENCE_4 = 'RCV_TRANSACTIONS'
AND GJR.REFERENCE_5 IN ('TRANSACTION_ID'
, TO_CHAR (JRT.TRANSACTION_ID))
AND GJR.REFERENCE_6 IN (TO_CHAR (JRT.TRANSACTION_ID)
, 'TRANSACTION_ID')
AND GJS.JE_SOURCE_NAME IN ('PURCHASING'
, 'PURCHASING INDIA')
AND (GJC.JE_CATEGORY_NAME = 'RECEIVING INDIA' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'RECEIVING INDIA') UNION ALL SELECT /*+ ORDERED USE_NL(JRH JRL) USE_NL(JRL JRT) USE_NL(JRT RSL) USE_NL(JRT JRRL) USE_NL(JRT JRR) USE_NL(JRT GJR) USE_NL(GJR GJH) USE_NL(GJH GJL) USE_NL(GJH GJS) USE_NL(GJH GJC) USE_NL(GJH GLCT) INDEX(GJR GL_IMPORT_REFERENCES_N3) */ 7000 APPLICATION_ID
, 'PO RECEIPT' EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC' TRX_CLASS
, 'JAI PO REC' TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS' TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, NULL UOM
, JRT.QUANTITY QUANTITY
, NULL LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL (JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO) EXCISE_INV_NUM
, NVL (JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, NVL (JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO) VAT_INV_NUM
, NVL (JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE) VAT_INVOICE_DATE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, NULL PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM JAI_RCV_HEADERS JRH
, JAI_RCV_LINES JRL
, JAI_RCV_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_RGM_LINES JRRL
, JAI_RGM_TRX_RECORDS JRR
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND JRH.RECEIPT_SOURCE_CODE IN ('VENDOR'
, 'INTERNAL ORDER')
AND RSL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRL.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+) = JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+) = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRT.TRANSACTION_ID = JRR.SOURCE_DOCUMENT_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'JAI_RGM_CLAIM_PKG.PROCESS_CLAIM'
AND GJR.REFERENCE_4 = 'JAI_RGM_TRX_RECORDS'
AND GJR.REFERENCE_5 = 'REPOSITORY_ID'
AND GJR.REFERENCE_6 = TO_CHAR (JRR.REPOSITORY_ID)
AND GJS.JE_SOURCE_NAME IN ('PURCHASING'
, 'PURCHASING INDIA')
AND (GJC.JE_CATEGORY_NAME = 'RECEIVING INDIA' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'RECEIVING INDIA') UNION ALL SELECT /*+ ORDERED USE_NL(JRH JRL) USE_NL(JRL JRT) USE_NL(JRT RSL) USE_NL(JRT JRRL) USE_NL(JRT JRR) USE_NL(JRT GJR) USE_NL(GJR GJH) USE_NL(GJH GJL) USE_NL(GJH GJS) USE_NL(GJH GJC) USE_NL(GJH GLCT) INDEX(GJR GL_IMPORT_REFERENCES_N3) */ 7000 APPLICATION_ID
, 'PO RECEIPT' EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC' TRX_CLASS
, 'JAI PO REC' TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS' TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, NULL UOM
, JRT.QUANTITY QUANTITY
, NULL LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL (JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO) EXCISE_INV_NUM
, NVL (JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, NVL (JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO) VAT_INV_NUM
, NVL (JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE) VAT_INVOICE_DATE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, NULL PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM JAI_RCV_HEADERS JRH
, JAI_RCV_LINES JRL
, JAI_RCV_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_RGM_LINES JRRL
, JAI_RGM_TRX_RECORDS JRR
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND JRH.RECEIPT_SOURCE_CODE = 'CUSTOMER'
AND RSL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRL.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+) = JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+) = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRT.TRANSACTION_ID = JRR.SOURCE_DOCUMENT_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'JAI_RGM_CLAIM_PKG.PROCESS_CLAIM'
AND GJR.REFERENCE_4 = 'JAI_RGM_TRX_RECORDS'
AND GJR.REFERENCE_5 = 'REPOSITORY_ID'
AND GJR.REFERENCE_6 = TO_CHAR (JRR.REPOSITORY_ID)
AND GJS.JE_SOURCE_NAME IN ('PURCHASING'
, 'PURCHASING INDIA')
AND (GJC.JE_CATEGORY_NAME = 'RECEIVING INDIA' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'RECEIVING INDIA') UNION ALL SELECT /*+ ORDERED USE_NL(JRH JRL) USE_NL(JRL JRT) USE_NL(JRT RSL) USE_NL(JRT JRRL) USE_NL(JRT GJR) USE_NL(GJR GJH) USE_NL(GJH GJL) USE_NL(GJH GJS) USE_NL(GJH GJC) USE_NL(GJH GLCT) INDEX(GJR GL_IMPORT_REFERENCES_N3) */ 7000 APPLICATION_ID
, 'PO RECEIPT' EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC' TRX_CLASS
, 'JAI PO REC' TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS' TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, NULL UOM
, JRT.QUANTITY QUANTITY
, NULL LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL (JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO) EXCISE_INV_NUM
, NVL (JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, NVL (JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO) VAT_INV_NUM
, NVL (JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE) VAT_INVOICE_DATE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, NULL PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM JAI_RCV_HEADERS JRH
, JAI_RCV_LINES JRL
, JAI_RCV_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_RGM_LINES JRRL
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE GJH.JE_CATEGORY = GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE = GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE
AND JRH.RECEIPT_SOURCE_CODE IN ('VENDOR'
, 'INTERNAL ORDER')
AND RSL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRL.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID = JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+) = JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+) = JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID = JRT.SHIPMENT_HEADER_ID
AND GJL.JE_HEADER_ID = GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM = GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID = GJH.JE_BATCH_ID
AND GJR.REFERENCE_2 = 'INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3 = 'JAI_RGM_CLAIM_PKG.PROCESS_VAT'
AND GJR.REFERENCE_4 = 'JAI_RCV_TRANSACTIONS'
AND GJR.REFERENCE_5 = 'TRANSACTION_ID'
AND GJR.REFERENCE_6 = TO_CHAR (JRT.TRANSACTION_ID)
AND GJS.JE_SOURCE_NAME IN ('PURCHASING'
, 'PURCHASING INDIA')
AND (GJC.JE_CATEGORY_NAME = 'RECEIVING INDIA' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'RECEIVING INDIA') UNION ALL SELECT 7000 APPLICATION_ID
, 'PO RECEIPT'EVENT_TYPE
, GJL.DESCRIPTION EVENT_DESCRIPTION
, 'JAI PO REC'TRX_CLASS
, 'JAI PO REC'TRX_CLASS_NAME
, JRT.TRANSACTION_TYPE TRX_TYPE
, JRT.SHIPMENT_HEADER_ID TRX_HDR_ID
, 'JAI_RCV_TRANSACTIONS'TRX_HDR_TABLE
, JRT.ORGANIZATION_ID INVENTORY_ORG_ID
, GJH.LEDGER_ID SET_OF_BOOKS_ID
, 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_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.ACCOUNTED_DR ACCOUNTED_DR
, GJL.ACCOUNTED_CR ACCOUNTED_CR
, GJH.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GJH.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GJH.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, GJL.CODE_COMBINATION_ID ACCOUNT_ID
, GJL.EFFECTIVE_DATE ACCOUNTING_DATE
, JRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRT.LAST_UPDATED_BY LAST_UPDATED_BY
, JRT.CREATION_DATE CREATION_DATE
, JRT.CREATED_BY CREATED_BY
, JRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RSL.LINE_NUM RECEIPT_LINE_NUMBER
, JRT.INVENTORY_ITEM_ID ITEM_ID
, UOM.UNIT_OF_MEASURE UOM
, JRT.QUANTITY QUANTITY
, HR.DESCRIPTION LOCATION
, RSL.TO_SUBINVENTORY SUB_INVENTORY
, NVL(JRH.EXCISE_INVOICE_NO
, JRL.EXCISE_INVOICE_NO)EXCISE_INV_NUM
, NVL(JRH.EXCISE_INVOICE_DATE
, JRL.EXCISE_INVOICE_DATE)EXCISE_INVOICE_DATE
, NVL(JRT.VAT_INVOICE_NO
, JRRL.INVOICE_NO)VAT_INV_NUM
, NVL(JRT.VAT_INVOICE_DATE
, JRRL.INVOICE_DATE)VAT_INVOICE_DATE
, PV.VENDOR_NAME PARTY_NAME
, PV.SEGMENT1 PARTY_NUMBER
, PVS.VENDOR_SITE_CODE PARTY_SITE
, JRT.RECEIPT_NUM RECEIPT_NUM
, JRT.TRANSACTION_DATE RECEIPT_DATE
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPPED_DATE SHIPMENT_DATE
FROM RCV_SHIPMENT_LINES RSL
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS HR
, MTL_UNITS_OF_MEASURE_VL UOM
, MTL_MATERIAL_TRANSACTIONS MMT
, JAI_RCV_LINES JRL
, JAI_RCV_RGM_LINES JRRL
, JAI_RCV_TRANSACTIONS JRT
, JAI_RCV_HEADERS JRH
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_CATEGORIES GJC
, GL_JE_SOURCES GJS
, GL_IMPORT_REFERENCES GJR
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
WHERE GJH.JE_CATEGORY=GJC.JE_CATEGORY_NAME
AND GJH.JE_SOURCE=GJS.JE_SOURCE_NAME
AND GJH.CURRENCY_CONVERSION_TYPE=GLCT.CONVERSION_TYPE
AND JRH.RECEIPT_SOURCE_CODE IN ('VENDOR'
, 'INTERNAL ORDER')
AND JRH.VENDOR_ID=PV.VENDOR_ID
AND JRH.VENDOR_SITE_ID=PVS.VENDOR_SITE_ID(+)
AND JRT.LOCATION_ID=HR.LOCATION_ID(+)
AND JRT.UOM_CODE=UOM.UOM_CODE
AND RSL.SHIPMENT_HEADER_ID=JRT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID=JRT.SHIPMENT_LINE_ID
AND JRL.SHIPMENT_HEADER_ID=JRT.SHIPMENT_HEADER_ID
AND JRL.SHIPMENT_LINE_ID=JRT.SHIPMENT_LINE_ID
AND JRRL.SHIPMENT_HEADER_ID(+)=JRT.SHIPMENT_HEADER_ID
AND JRRL.SHIPMENT_LINE_ID(+)=JRT.SHIPMENT_LINE_ID
AND JRH.SHIPMENT_HEADER_ID=JRT.SHIPMENT_HEADER_ID
AND GJL.JE_HEADER_ID=GJH.JE_HEADER_ID
AND GJR.JE_HEADER_ID=GJL.JE_HEADER_ID
AND GJR.JE_LINE_NUM=GJL.JE_LINE_NUM
AND GJR.JE_BATCH_ID=GJH.JE_BATCH_ID
AND GJR.REFERENCE_2='INDIA LOCALIZATION ENTRY'
AND GJR.REFERENCE_3='JAI_RCV_DELIVER_RTR_PKG.STANDARD_COSTING'
AND GJR.REFERENCE_4='RCV_TRANSACTIONS'
AND GJR.REFERENCE_5=TO_CHAR(JRT.TRANSACTION_ID)
AND GJR.REFERENCE_6=TO_CHAR(MMT.TRANSACTION_ID)
AND GJS.JE_SOURCE_NAME='INVENTORY INDIA'
AND (GJC.JE_CATEGORY_NAME = 'MTL' OR JAI_DRILLDOWN_UTILS_PKG.GET_USER_CATEG_NAME(GJC.JE_CATEGORY_NAME) = 'MTL')
AND MMT.TRANSACTION_TYPE_ID = 80
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 13
AND MMT.TRANSACTION_ACTION_ID = 24
AND MMT.TRANSACTION_REFERENCE = TO_CHAR(JRT.TRANSACTION_ID)

Columns

Name
APPLICATION_ID
EVENT_TYPE
EVENT_DESCRIPTION
TRX_CLASS
TRX_CLASS_NAME
TRX_TYPE
TRX_HDR_ID
TRX_HDR_TABLE
INVENTORY_ORG_ID
SET_OF_BOOKS_ID
JE_CATEGORY
USER_JE_CATEGORY_NAME
JE_SOURCE
USER_JE_SOURCE_NAME
JE_HEADER_ID
JE_LINE_NUM
ENTERED_CURRENCY
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_TYPE
CURRENCY_USER_CONVERSION_TYPE
ACCOUNT_ID
ACCOUNTING_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
RECEIPT_LINE_NUMBER
ITEM_ID
UOM
QUANTITY
LOCATION
SUB_INVENTORY
EXCISE_INV_NUM
EXCISE_INVOICE_DATE
VAT_INV_NUM
VAT_INVOICE_DATE
PARTY_NAME
PARTY_NUMBER
PARTY_SITE
RECEIPT_NUM
RECEIPT_DATE
SHIPMENT_NUM
SHIPMENT_DATE