DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on PO_VENDOR_SITES_ALL

Line 137: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri

133: l_apps_version number;
134: l_po_application VARCHAR2(2) := 'PO' ;
135:
136: Cursor c1 is select pvsa.vendor_site_id,pri.rowid
137: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri
138: where pri.suggested_vendor_id = pvsa.vendor_id
139: and pri.suggested_vendor_site = pvsa.vendor_site_code
140: and pri.org_id = pvsa.org_id
141: and pri.interface_source_code = 'MSC';

Line 507: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri

503: lv_result BOOLEAN;
504:
505:
506: Cursor c1 is select pvsa.vendor_site_id,pri.rowid
507: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri
508: where pri.suggested_vendor_id = pvsa.vendor_id
509: and pri.suggested_vendor_site = pvsa.vendor_site_code
510: and pri.org_id = pvsa.org_id
511: and pri.interface_source_code = 'MSC';