DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 565: from hr_organization_information hoi, rcv_transactions rt, rcv_staging_table rst, mtl_parameters mp

561: Bug 4670527 */
562: delete rcv_staging_table
563: where transaction_id IN
564: (select distinct(rst.transaction_id)
565: from hr_organization_information hoi, rcv_transactions rt, rcv_staging_table rst, mtl_parameters mp
566: where rt.SOURCE_DOCUMENT_CODE = 'PO'
567: and hoi.ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
568: and hoi.ORG_INFORMATION3 = to_char(rt.vendor_id)
569: and hoi.ORG_INFORMATION4 = to_char(rt.vendor_site_id)