DBA Data[Home] [Help]

APPS.PO_ASL_SV dependencies on PO_VENDOR_SITES_ALL

Line 250: and exists (select null from po_vendor_sites_all pvsa

246: where pasl.using_organization_id = x_organization_id
247: and pasl.vendor_id = x_vendor_id
248: and pasl.vendor_site_id = NVL(x_vendor_site_id,pasl.vendor_site_id)
249: and pasl.item_id = NVL(x_item_id,pasl.item_id)
250: and exists (select null from po_vendor_sites_all pvsa
251: where NVL(pvsa.org_id, -99) =
252: NVL(x_org_id, NVL(pvsa.org_id, -99))
253: and pvsa.vendor_site_id = pasl.vendor_site_id)
254: RETURNING PASL.asl_id --

Line 265: and exists (select null from po_vendor_sites_all pvsa

261: where pasl.using_organization_id in (x_organization_id,-1)
262: and pasl.vendor_id = x_vendor_id
263: and pasl.vendor_site_id = NVL(x_vendor_site_id,pasl.vendor_site_id)
264: and pasl.item_id = NVL(x_item_id,pasl.item_id)
265: and exists (select null from po_vendor_sites_all pvsa
266: where NVL(pvsa.org_id, -99) =
267: NVL(x_org_id, NVL(pvsa.org_id, -99))
268: and pvsa.vendor_site_id = pasl.vendor_site_id)
269: RETURNING PASL.asl_id --

Line 878: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

874: l_using_org_id PO_APPROVED_SUPPLIER_LIST.using_organization_id%TYPE;
875: l_organization VARCHAR2(30);
876: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;
877: l_vendor_name PO_VENDORS.vendor_name%TYPE;
878: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
879: l_category_name MTL_CATEGORIES_KFV.concatenated_segments%TYPE;
880: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
881:
882: BEGIN

Line 913: po_vendor_sites_all PVS,

909: FROM po_approved_supplier_list PASL,
910: mtl_parameters MP,
911: mtl_manufacturers MM,
912: po_vendors PV,
913: po_vendor_sites_all PVS,
914: mtl_system_items_kfv MSI,
915: mtl_categories_kfv MC
916: WHERE PASL.asl_id = p_asl_id
917: AND PASL.using_organization_id = MP.organization_id (+)