APPS.POS_CREATE_ASN dependencies on RCV_TRANSACTIONS_INTERFACE

Line 343: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

339: P_ITEM_ID_T,
340: P_QUANTITY_T);
341:
342: x_progress := '090' ;
343: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
344: into l_iface_txn_id
345: from dual;
346:
347: x_progress := '100' ;

Line 363: insert into rcv_transactions_interface

359: l_primary_unit_of_measure, l_converted_qty);
360:
361:
362:
363: insert into rcv_transactions_interface
364: ( INTERFACE_TRANSACTION_ID ,
365: HEADER_INTERFACE_ID ,
366: GROUP_ID ,
367: TRANSACTION_TYPE ,

Line 525: from rcv_transactions_interface

521: where po_header_id = p_po_header_id_t;
522:
523: select count(*)
524: into x_note_count
525: from rcv_transactions_interface
526: where header_interface_id = l_header_id;
527:
528: k := k + x_note_count;
529:

Line 731: FROM rcv_transactions_interface

727: SELECT nvl(sum(primary_quantity),0),
728: min(primary_unit_of_measure)
729: INTO x_interface_quantity,
730: x_primary_uom
731: FROM rcv_transactions_interface
732: WHERE processing_status_code = 'PENDING'
733: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP')
734: AND po_line_location_id = p_line_location_id;
735:

Line 948: from rcv_transactions_interface rti, rcv_headers_interface rhi

944:
945: -- All PO's for a particular group id should have the same org_id
946: select max(po_header_id)
947: into l_po_header_id
948: from rcv_transactions_interface rti, rcv_headers_interface rhi
949: where rhi.group_id = p_groupId
950: and rhi.header_interface_id = rti.header_interface_id
951: group by rti.header_interface_id;
952: