DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 342: from po_location_associations_all pla

338: country = p_country;
339:
340: select count(*)
341: into x_pla_count
342: from po_location_associations_all pla
343: where pla.org_id = p_org_id
344: and pla.location_id = p_ship_to_location_id
345: and pla.vendor_id is not null
346: and pla.vendor_site_id is not null;

Line 410: from po_location_associations_all pla

406:
407:
408: select count(*)
409: into x_pla_count
410: from po_location_associations_all pla
411: where pla.org_id = p_org_id
412: and pla.location_id = p_ship_to_location_id
413: and pla.vendor_id is not null
414: and pla.vendor_site_id is not null;