APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 1195: , rcv_shipment_headers rsh

1191: , rs.to_subinventory from_subinventory_code
1192: , rs.to_locator_id from_locator_id
1193: FROM rcv_transactions rt
1194: , rcv_supply rs
1195: , rcv_shipment_headers rsh
1196: , rcv_shipment_lines rsl
1197: , po_lines pol
1198: , mtl_system_items msi
1199: WHERE rs.rcv_transaction_id = v_rcv_txn_id

Line 1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1220: l_parent_txn_id NUMBER;
1221: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1222:
1223: l_progress NUMBER; --Index to track progress and log error

Line 1630: , rcv_shipment_headers rsh

1626: , rs.to_subinventory from_subinventory_code
1627: , rs.to_locator_id from_locator_id
1628: FROM rcv_transactions rt
1629: , rcv_supply rs
1630: , rcv_shipment_headers rsh
1631: , rcv_shipment_lines rsl
1632: , mtl_system_items msi
1633: WHERE rs.rcv_transaction_id = v_rcv_txn_id
1634: AND rs.to_organization_id = p_organization_id

Line 1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1653: l_parent_txn_id NUMBER;
1654: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1655: l_progress NUMBER; --Index to track progress and log error
1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

Line 2046: , rcv_shipment_headers rsh

2042: , rs.to_subinventory from_subinventory_code
2043: , rs.to_locator_id from_locator_id
2044: FROM rcv_transactions rt
2045: , rcv_supply rs
2046: , rcv_shipment_headers rsh
2047: , rcv_shipment_lines rsl
2048: , mtl_system_items msi
2049: WHERE rs.rcv_transaction_id = v_rcv_txn_id
2050: AND rs.to_organization_id = p_organization_id

Line 2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;

2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
2069: l_parent_txn_id NUMBER;
2070: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
2071:
2072: l_progress NUMBER; --Index to track progress and log error

Line 2965: rcv_shipment_headers rsh,

2961: FROM rcv_supply rs,
2962: rcv_transactions rt,
2963: rcv_serials_supply rss,
2964: rcv_shipment_lines rsl,
2965: rcv_shipment_headers rsh,
2966: mtl_serial_numbers_interface msni
2967: WHERE rs.item_id = p_item_id
2968: AND Nvl(rs.item_revision,nvl(p_revision,'@@@')) = nvl(p_revision,'@@@')
2969: AND rs.to_organization_id = p_organization_id

Line 3012: rcv_shipment_headers rsh

3008: FROM rcv_supply rs,
3009: rcv_transactions rt,
3010: rcv_shipment_lines rsl,
3011: rcv_lots_supply rls,
3012: rcv_shipment_headers rsh
3013: WHERE rs.item_id = p_item_id
3014: AND Nvl(rs.item_revision,nvl(p_revision,'@@@@')) = nvl(p_revision,'@@@@')
3015: AND rs.to_organization_id = p_organization_id
3016: AND nvl(rs.lpn_id,-1) = nvl(p_lpn_id,-1)