APPS.POS_ASN_CREATE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 346: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_serial_txn_temp_id from dual;

342:
343: l_uom := po_uom_s.get_primary_uom(l_inventory_item_id,l_org_id,p_transaction_uom);
344: -- Bug 7476612 - End
345:
346: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_serial_txn_temp_id from dual;
347:
348: PO_UOM_S.uom_convert (
349: from_quantity => p_transaction_quantity,
350: from_uom => p_transaction_uom,

Line 1151: FROM rcv_transactions_interface

1147: SELECT nvl(sum(primary_quantity),0),
1148: min(primary_unit_of_measure)
1149: INTO x_interface_quantity,
1150: x_primary_uom
1151: FROM rcv_transactions_interface
1152: WHERE processing_status_code = 'PENDING'
1153: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP')
1154: AND po_line_location_id = p_line_location_id;
1155:

Line 1365: from rcv_transactions_interface rti,

1361: /*only for I*/
1362:
1363: select count(*)
1364: into l_rows
1365: from rcv_transactions_interface rti,
1366: mtl_transaction_lots_interface mtli
1367: where rti.INTERFACE_TRANSACTION_ID = mtli.PRODUCT_TRANSACTION_ID
1368: and mtli.PRODUCT_CODE = 'RCV'
1369: and rti.INTERFACE_TRANSACTION_ID = p_asn_line_id

Line 1410: rcv_transactions_interface rti

1406: /*only for I*/
1407: select count(*)
1408: into l_rows
1409: from mtl_serial_numbers_interface msni,
1410: rcv_transactions_interface rti
1411: where rti.INTERFACE_TRANSACTION_ID = msni.PRODUCT_TRANSACTION_ID
1412: and msni.PRODUCT_CODE = 'RCV'
1413: and rti.INTERFACE_TRANSACTION_ID = p_asn_line_id
1414: and msni.FM_SERIAL_NUMBER is not null;

Line 1457: from rcv_transactions_interface rti, po_headers_all poh, po_releases_all por,

1453: /*only for I*/
1454:
1455: select count(*)
1456: into l_rows
1457: from rcv_transactions_interface rti, po_headers_all poh, po_releases_all por,
1458: po_line_locations_all pll
1459: where rti.po_header_id = poh.po_header_id
1460: and rti.po_release_id = por.po_release_id(+)
1461: and rti.po_line_location_id = pll.line_location_id

Line 1648: FROM rcv_transactions_interface rti

1644: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
1645: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
1646: INTO x_interface_quantity,
1647: x_primary_uom
1648: FROM rcv_transactions_interface rti
1649: WHERE (transaction_status_code = 'PENDING'
1650: and processing_status_code <> 'ERROR')
1651: AND transaction_type IN ('RECEIVE', 'MATCH','CORRECT','SHIP','CANCEL') -- bug 657347 should include 'SHIP'
1652: -- when calculating total quantity

Line 1815: FROM rcv_transactions_interface rti

1811: SELECT nvl(sum(decode(nvl(order_transaction_id,-999),-999,primary_quantity,nvl(interface_transaction_qty,0))),0),
1812: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
1813: INTO x_interface_quantity,
1814: x_primary_uom
1815: FROM rcv_transactions_interface rti
1816: WHERE (transaction_status_code = 'PENDING'
1817: and processing_status_code <> 'ERROR')
1818: AND transaction_type IN ('SHIP')
1819: AND NOT EXISTS(SELECT 1 FROM rcv_transactions rt