APPS.POS_ASN dependencies on POS_ASN_SHOP_CART_HEADERS

Line 108: pos_asn_shop_cart_headers ph,

104: UNIT_OF_MEASURE,
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;

Line 144: from pos_asn_shop_cart_headers ph,

140: ph.carrier_method p_carrier_method,
141: ph.freight_bill_number p_freight_bill_num
142: -- null p_receipt_num,
143: -- null p_ussgl_txn_code
144: from pos_asn_shop_cart_headers ph,
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'

Line 162: from pos_asn_shop_cart_headers posh,

158: nvl(posd.expected_receipt_date, posh.expected_receipt_date)
159: expected_receipt_date,
160: posh.vendor_id supplier_id,
161: pov.vendor_name supplier
162: from pos_asn_shop_cart_headers posh,
163: pos_asn_shop_cart_details posd,
164: po_headers_all poh,
165: po_vendors pov
166: where posh.session_id = l_session_id and