APPS.POS_ASN_CREATE_PVT dependencies on RCV_TRANSACTIONS

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

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

Line 1150: FROM rcv_transactions_interface

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

Line 1364: from rcv_transactions_interface rti,

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

Line 1377: from rcv_shipment_lines rsl, rcv_transactions rt,

1373:
1374:
1375: select count(*)
1376: into l_rows
1377: from rcv_shipment_lines rsl, rcv_transactions rt,
1378: mtl_transaction_lot_numbers mtln
1379: where rsl.shipment_line_id = rt.shipment_line_id
1380: and rt.transaction_type = 'RECEIVE'
1381: and rt.transaction_id = mtln.PRODUCT_TRANSACTION_ID

Line 1409: rcv_transactions_interface rti

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

Line 1421: from rcv_shipment_lines rsl, rcv_transactions rt,

1417:
1418: /*only for S*/
1419: select count(*)
1420: into l_rows
1421: from rcv_shipment_lines rsl, rcv_transactions rt,
1422: mtl_unit_transactions mut
1423: where rsl.shipment_line_id = rt.shipment_line_id
1424: and rt.transaction_type = 'RECEIVE'
1425: and rt.transaction_id = mut.PRODUCT_TRANSACTION_ID

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

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