APPS.POS_ASN_XML dependencies on RCV_TRANSACTIONS_INTERFACE

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

248: p_line_num,
249: p_po_shipment_line_num,
250: p_error_message
251: from
252: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
253: po_line_locations_all poll
254: where
255: pie.interface_header_id = rti.header_interface_id and
256: pie.interface_type in ('RECEIVING','RCV-856') and

Line 266: rcv_transactions_interface rti, po_interface_errors pie

262:
263: select count(*)
264: into l_count
265: from
266: rcv_transactions_interface rti, po_interface_errors pie
267: where
268: pie.interface_header_id = rti.header_interface_id and
269: -- pie.interface_type in ('RECEIVING','RCV-856') and
270: rti.group_id = p_group_id;

Line 282: rcv_transactions_interface rti, po_interface_errors pie

278: min(pie.error_message)
279: into
280: p_error_message
281: from
282: rcv_transactions_interface rti, po_interface_errors pie
283: where
284: pie.interface_header_id = rti.header_interface_id and
285: -- pie.interface_type in ('RECEIVING','RCV-856') and
286: rti.group_id = p_group_id;

Line 946: from rcv_transactions_interface

942:
943: select count(*)
944: into x_ship_org_count
945: from (select distinct to_organization_id
946: from rcv_transactions_interface
947: where header_interface_id = p_header_interface_id);
948:
949:
950: if (x_ship_org_count = 1) then

Line 963: rcv_transactions_interface

959: p_ship_to_org_id,
960: p_vendor_id,
961: p_vendor_site_id
962: from
963: rcv_transactions_interface
964: where
965: header_interface_id = p_header_interface_id;
966:
967: update rcv_headers_interface

Line 1275: SELECT Count(*) INTO l_count FROM rcv_transactions_interface;

1271: l_count NUMBER := 0;
1272: h_count NUMBER :=0;
1273: BEGIN
1274: p_error_code := 0;
1275: SELECT Count(*) INTO l_count FROM rcv_transactions_interface;
1276: SELECT Count(*) INTO h_count FROM rcv_headers_interface hdr WHERE creation_date >= SYSDATE -1;
1277: select interface_transaction_id
1278: into wms_interface_transaction_id
1279: from rcv_transactions_interface

Line 1279: from rcv_transactions_interface

1275: SELECT Count(*) INTO l_count FROM rcv_transactions_interface;
1276: SELECT Count(*) INTO h_count FROM rcv_headers_interface hdr WHERE creation_date >= SYSDATE -1;
1277: select interface_transaction_id
1278: into wms_interface_transaction_id
1279: from rcv_transactions_interface
1280: where item_num = item
1281: AND Nvl(item_revision,'-1') = Nvl(item_rev,'-1')
1282: AND Nvl(DOCUMENT_NUM,'-1') = Nvl(doc_num, '-1')
1283: AND Nvl(PO_REVISION_NUM,'-1') = Nvl(doc_rev_num, '-1')