APPS.POS_ASN_XML dependencies on RCV_TRANSACTIONS_INTERFACE

Line 242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,

238: p_line_num,
239: p_po_shipment_line_num,
240: p_error_message
241: from
242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
243: po_line_locations_all poll
244: where
245: pie.interface_header_id = rti.header_interface_id and
246: pie.interface_type in ('RECEIVING','RCV-856') and

Line 256: rcv_transactions_interface rti, po_interface_errors pie

252:
253: select count(*)
254: into l_count
255: from
256: rcv_transactions_interface rti, po_interface_errors pie
257: where
258: pie.interface_header_id = rti.header_interface_id and
259: -- pie.interface_type in ('RECEIVING','RCV-856') and
260: rti.group_id = p_group_id;

Line 272: rcv_transactions_interface rti, po_interface_errors pie

268: min(pie.error_message)
269: into
270: p_error_message
271: from
272: rcv_transactions_interface rti, po_interface_errors pie
273: where
274: pie.interface_header_id = rti.header_interface_id and
275: -- pie.interface_type in ('RECEIVING','RCV-856') and
276: rti.group_id = p_group_id;

Line 916: from rcv_transactions_interface

912:
913: select count(*)
914: into x_ship_org_count
915: from (select distinct to_organization_id
916: from rcv_transactions_interface
917: where header_interface_id = p_header_interface_id);
918:
919:
920: if (x_ship_org_count = 1) then

Line 933: rcv_transactions_interface

929: p_ship_to_org_id,
930: p_vendor_id,
931: p_vendor_site_id
932: from
933: rcv_transactions_interface
934: where
935: header_interface_id = p_header_interface_id;
936:
937: update rcv_headers_interface