APPS.POS_ASN dependencies on POS_ASN_SHOP_CART_DETAILS

Line 39: pos_asn_shop_cart_details asnd

35: TO_CHAR(ASND.ASN_LINE_SPLIT_ID)) error_seq,
36: replace(replace(err.error_message, '
37: ', null), '''', '\''') error_message
38: from po_interface_errors err,
39: pos_asn_shop_cart_details asnd
40: where err.INTERFACE_HEADER_ID = l_header_id and
41: asnd.HEADER_INTERFACE_ID = err.INTERFACE_HEADER_ID and
42: asnd.INTERFACE_TRANSACTION_ID = err.INTERFACE_LINE_ID;
43:

Line 107: from pos_asn_shop_cart_details pl,

103: POS_QUANTITIES_S.get_invoice_qty(PO_LINE_LOCATION_ID,
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

Line 145: pos_asn_shop_cart_details pl

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'
149: from po_location_associations pla

Line 163: pos_asn_shop_cart_details posd,

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
167: posd.session_id = l_session_id and