DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on PO_VENDOR_SITES_ALL

Line 2786: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri

2782: var_revision VARCHAR2(3);
2783: var_revision_ctrl NUMBER;
2784:
2785: Cursor c1 is select pvsa.vendor_site_id,pri.rowid,pri.item_id, pri.destination_organization_id,pri.charge_account_id,pri.project_id
2786: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri
2787: where pri.suggested_vendor_id = pvsa.vendor_id(+)
2788: and pri.suggested_vendor_site = pvsa.vendor_site_code(+)
2789: and nvl(pri.org_id,-99) = nvl(pvsa.org_id(+),-99)
2790: and pri.interface_source_code = 'MSC'