DBA Data[Home] [Help]

APPS.POS_ASN dependencies on PO_LOCATION_ASSOCIATIONS

Line 109: po_location_associations pla

105: ITEM_ID,
106: QUANTITY_SHIPPED) QUANTITY_INVOICED
107: from pos_asn_shop_cart_details pl,
108: pos_asn_shop_cart_headers ph,
109: po_location_associations pla
110: where pl.session_id = l_session_id and
111: ph.session_id = l_session_id and
112: pla.location_id(+) = ph.ship_to_location_id;
113:

Line 149: from po_location_associations pla

145: pos_asn_shop_cart_details pl
146: where ph.session_id = l_session_id and
147: pl.session_id = l_session_id and
148: exists (select 'ok'
149: from po_location_associations pla
150: where pla.location_id = ph.ship_to_location_id and
151: pla.vendor_id is not null and
152: pla.vendor_site_id is not null);
153: