eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2989: rcv_shipment_headers rsh,

2985: FROM rcv_supply rs,
2986: rcv_transactions rt,
2987: rcv_serials_supply rss,
2988: rcv_shipment_lines rsl,
2989: rcv_shipment_headers rsh,
2990: mtl_serial_numbers_interface msni
2991: WHERE rs.item_id = p_item_id
2992: -- AND Nvl(rs.item_revision,nvl(p_revision,'@@@')) = nvl(p_revision,'@@@') BUG13562127
2993: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)

Line 3040: rcv_shipment_headers rsh,

3036: ,rsl.asn_line_flag asn_line_flag
3037: FROM rcv_supply rs,
3038: rcv_transactions rt,
3039: rcv_shipment_lines rsl,
3040: rcv_shipment_headers rsh,
3041: mtl_serial_numbers_interface msni,
3042: mtl_transaction_lots_interface mtli
3043: WHERE rs.item_id = p_item_id
3044: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)

Line 3095: rcv_shipment_headers rsh

3091: FROM rcv_supply rs,
3092: rcv_transactions rt,
3093: rcv_shipment_lines rsl,
3094: rcv_lots_supply rls,
3095: rcv_shipment_headers rsh
3096: WHERE rs.item_id = p_item_id
3097: -- AND Nvl(rs.item_revision,nvl(p_revision,'@@@@')) = nvl(p_revision,'@@@@') --BUG13562127
3098: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)
3099: AND rs.to_organization_id = p_organization_id