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: APPS.JAI_PO_REC_VENDOR_AEL_V

Source

View Text - Preformatted


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, jrt.excise_invoice_no excise_inv_num, jrt.excise_invoice_date excise_invoice_date, jrt.vat_invoice_no vat_inv_num, jrt.vat_invoice_date vat_invoice_date, decode(jrh.receipt_source_code , 'VENDOR' , ( SELECT vendor_name FROM po_vendors WHERE jrh.vendor_id = vendor_id(+)) , ( SELECT customer_name FROM jai_customers_v WHERE jrh.customer_id = customer_id(+))) party_name, decode(jrh.receipt_source_code , 'VENDOR' , (select segment1 from po_vendors where jrh.vendor_id = vendor_id(+)) , (select customer_number from jai_customers_v where jrh.customer_id = customer_id(+))) party_number, decode(jrh.receipt_source_code , 'VENDOR' , (select vendor_site_code from po_vendor_sites_all where jrh.vendor_id = vendor_id(+) and jrh.vendor_site_id = vendor_site_id(+)) , (select Location from hz_cust_site_uses_all where jrh.customer_site_id = site_use_id(+))) 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_transactions jrt, rcv_shipment_lines rsl, mtl_units_of_measure_vl uom, hr_locations hr, gl_je_sources gjs, gl_je_categories gjc, GL_JE_HEADERS gjh, GL_JE_LINES gjl , gl_daily_conversion_types glct, GL_IMPORT_REFERENCES gjr 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 jrt.location_id = hr.location_id(+) AND jrt.uom_code = uom.uom_code(+) 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 TO_NUMBER(DECODE(RTRIM(TRANSLATE(gjr.reference_5,'0123456789',' ')), NULL, gjr.reference_5,-99999)) = jrt.transaction_id AND gjr.reference_6 = 'transaction_id' AND gjs.user_je_source_name = 'Purchasing India' AND gjc.user_je_category_name = 'Receiving India'

View Text - HTML Formatted

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
, JRT.EXCISE_INVOICE_NO EXCISE_INV_NUM
, JRT.EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, JRT.VAT_INVOICE_NO VAT_INV_NUM
, JRT.VAT_INVOICE_DATE VAT_INVOICE_DATE
, DECODE(JRH.RECEIPT_SOURCE_CODE
, 'VENDOR'
, ( SELECT VENDOR_NAME
FROM PO_VENDORS
WHERE JRH.VENDOR_ID = VENDOR_ID(+))
, ( SELECT CUSTOMER_NAME
FROM JAI_CUSTOMERS_V
WHERE JRH.CUSTOMER_ID = CUSTOMER_ID(+))) PARTY_NAME
, DECODE(JRH.RECEIPT_SOURCE_CODE
, 'VENDOR'
, (SELECT SEGMENT1
FROM PO_VENDORS
WHERE JRH.VENDOR_ID = VENDOR_ID(+))
, (SELECT CUSTOMER_NUMBER
FROM JAI_CUSTOMERS_V
WHERE JRH.CUSTOMER_ID = CUSTOMER_ID(+))) PARTY_NUMBER
, DECODE(JRH.RECEIPT_SOURCE_CODE
, 'VENDOR'
, (SELECT VENDOR_SITE_CODE
FROM PO_VENDOR_SITES_ALL
WHERE JRH.VENDOR_ID = VENDOR_ID(+)
AND JRH.VENDOR_SITE_ID = VENDOR_SITE_ID(+))
, (SELECT LOCATION
FROM HZ_CUST_SITE_USES_ALL
WHERE JRH.CUSTOMER_SITE_ID = SITE_USE_ID(+))) 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_TRANSACTIONS JRT
, RCV_SHIPMENT_LINES RSL
, MTL_UNITS_OF_MEASURE_VL UOM
, HR_LOCATIONS HR
, GL_JE_SOURCES GJS
, GL_JE_CATEGORIES GJC
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_IMPORT_REFERENCES GJR
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 JRT.LOCATION_ID = HR.LOCATION_ID(+)
AND JRT.UOM_CODE = UOM.UOM_CODE(+)
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 TO_NUMBER(DECODE(RTRIM(TRANSLATE(GJR.REFERENCE_5
, '0123456789'
, ' '))
, NULL
, GJR.REFERENCE_5
, -99999)) = JRT.TRANSACTION_ID
AND GJR.REFERENCE_6 = 'TRANSACTION_ID'
AND GJS.USER_JE_SOURCE_NAME = 'PURCHASING INDIA'
AND GJC.USER_JE_CATEGORY_NAME = 'RECEIVING INDIA'