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 709: FROM rcv_transactions_interface

705: SELECT nvl(sum(primary_quantity),0),
706: min(primary_unit_of_measure)
707: INTO x_interface_quantity,
708: x_primary_uom
709: FROM rcv_transactions_interface
710: WHERE processing_status_code = 'PENDING'
711: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP')
712: AND po_line_location_id = p_line_location_id;
713:

Line 844: from rcv_transactions_interface rti, rcv_headers_interface rhi

840:
841: -- All PO's for a particular group id should have the same org_id
842: select max(po_header_id)
843: into l_po_header_id
844: from rcv_transactions_interface rti, rcv_headers_interface rhi
845: where rhi.group_id = p_groupId
846: and rhi.header_interface_id = rti.header_interface_id
847: group by rti.header_interface_id;
848: