DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 363: from po_location_associations_all pla

359: p_ship_to_location_id := l_location_id;
360:
361: select count(*)
362: into x_pla_count
363: from po_location_associations_all pla
364: where pla.org_id = p_org_id
365: and pla.location_id = p_ship_to_location_id
366: and pla.vendor_id is not null
367: and pla.vendor_site_id is not null;

Line 431: from po_location_associations_all pla

427:
428:
429: select count(*)
430: into x_pla_count
431: from po_location_associations_all pla
432: where pla.org_id = p_org_id
433: and pla.location_id = p_ship_to_location_id
434: and pla.vendor_id is not null
435: and pla.vendor_site_id is not null;