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_QUANTITY_TREE_PVT dependencies on MTL_RESERVATIONS

Line 539: FROM mtl_reservations mr

535: , lpn_id lpn_id
536: , to_number(NULL) transaction_action_id
537: , to_char(NULL) transfer_subinventory_code
538: , to_number(NULL) transfer_locator_id
539: FROM mtl_reservations mr
540: WHERE
541: Nvl(mr.supply_source_type_id, 13) = 13
542: AND mr.primary_reservation_quantity > Nvl(mr.detailed_quantity,0) '
543: || l_reservation_where;

Line 5202: FROM mtl_reservations mr

5198: , lpn_id lpn_id
5199: , to_number(NULL) transaction_action_id
5200: , to_char(NULL) transfer_subinventory_code
5201: , to_number(NULL) transfer_locator_id
5202: FROM mtl_reservations mr
5203: WHERE
5204: Nvl(mr.supply_source_type_id, 13) = 13
5205: AND mr.primary_reservation_quantity > Nvl(mr.detailed_quantity,0)
5206: AND ((l_no_lpn_reservations <>1) OR (l_no_lpn_reservations = 1 AND mr.lpn_id IS NULL))

Line 5397: FROM mtl_reservations mr

5393: , to_number(NULL) transaction_action_id
5394: , to_char(NULL) transfer_subinventory_code
5395: , to_number(NULL) transfer_locator_id
5396: , to_number(NULL) status_id -- Onhand Material Status Support
5397: FROM mtl_reservations mr
5398: WHERE
5399: Nvl(mr.supply_source_type_id, 13) = 13
5400: AND mr.primary_reservation_quantity >
5401: Nvl(mr.detailed_quantity,0)

Line 5674: FROM mtl_reservations mr

5670: , lpn_id lpn_id
5671: , to_number(NULL) transaction_action_id
5672: , to_char(NULL) transfer_subinventory_code
5673: , to_number(NULL) transfer_locator_id
5674: FROM mtl_reservations mr
5675: WHERE
5676: Nvl(mr.supply_source_type_id, 13) = 13
5677: AND mr.primary_reservation_quantity >
5678: Nvl(mr.detailed_quantity,0)

Line 5954: FROM mtl_reservations mr

5950: , to_number(NULL) transaction_action_id
5951: , to_char(NULL) transfer_subinventory_code
5952: , to_number(NULL) transfer_locator_id
5953: , to_number(NULL) status_id -- Onhand Material Status Support
5954: FROM mtl_reservations mr
5955: WHERE
5956: Nvl(mr.supply_source_type_id, 13) = 13
5957: AND mr.primary_reservation_quantity >
5958: Nvl(mr.detailed_quantity,0)

Line 6330: FROM mtl_reservations mr

6326: , lpn_id lpn_id
6327: , to_number(NULL) transaction_action_id
6328: , to_char(NULL) transfer_subinventory_code
6329: , to_number(NULL) transfer_locator_id
6330: FROM mtl_reservations mr
6331: WHERE
6332: Nvl(mr.supply_source_type_id, 13) = 13
6333: AND mr.primary_reservation_quantity >
6334: Nvl(mr.detailed_quantity,0)

Line 6611: FROM mtl_reservations mr

6607: , to_number(NULL) transaction_action_id
6608: , to_char(NULL) transfer_subinventory_code
6609: , to_number(NULL) transfer_locator_id
6610: , to_number(NULL) status_id -- Onhand Material Status Support
6611: FROM mtl_reservations mr
6612: WHERE
6613: Nvl(mr.supply_source_type_id, 13) = 13
6614: AND mr.primary_reservation_quantity >
6615: Nvl(mr.detailed_quantity,0)

Line 6984: FROM mtl_reservations mr

6980: , lpn_id lpn_id
6981: , to_number(NULL) transaction_action_id
6982: , to_char(NULL) transfer_subinventory_code
6983: , to_number(NULL) transfer_locator_id
6984: FROM mtl_reservations mr
6985: WHERE
6986: Nvl(mr.supply_source_type_id, 13) = 13
6987: AND mr.primary_reservation_quantity > Nvl(mr.detailed_quantity,0)
6988: AND ((l_no_lpn_reservations <>1)

Line 7266: FROM mtl_reservations mr

7262: , lpn_id lpn_id
7263: , to_number(NULL) transaction_action_id
7264: , to_char(NULL) transfer_subinventory_code
7265: , to_number(NULL) transfer_locator_id
7266: FROM mtl_reservations mr
7267: WHERE
7268: Nvl(mr.supply_source_type_id, 13) = 13
7269: AND mr.primary_reservation_quantity >
7270: Nvl(mr.detailed_quantity,0)

Line 7686: FROM mtl_reservations mr

7682: , lpn_id lpn_id
7683: , to_number(NULL) transaction_action_id
7684: , to_char(NULL) transfer_subinventory_code
7685: , to_number(NULL) transfer_locator_id
7686: FROM mtl_reservations mr
7687: WHERE
7688: Nvl(mr.supply_source_type_id, 13) = 13
7689: AND mr.primary_reservation_quantity >
7690: Nvl(mr.detailed_quantity,0)

Line 8693: -- To do this, it queries the mtl_reservations table to find

8689:
8690: --add_demand_qty
8691: -- When in transaction_mode, this procedure will fix
8692: -- the quantity tree to reflect the correct available quantities.
8693: -- To do this, it queries the mtl_reservations table to find
8694: -- reservations which correspond to the demand info. For each
8695: -- reservation, it calls add_quantities to subtract those reservations
8696: -- from the quantity tree (since that quantity should be available
8697: -- for this transaction). We call add_quantities with a negative

Line 8724: -- use of the indices on mtl_reservations, while avoid dynamic sql.

8720: l_mult NUMBER := -1;
8721:
8722:
8723: --We need 6 possible queries to improve performance and make best
8724: -- use of the indices on mtl_reservations, while avoid dynamic sql.
8725:
8726: -- demand line is not NULL, not pick release
8727: -- Bug 4494038: exclude crossdock reservations
8728: CURSOR c_demand_dl IS

Line 8736: FROM mtl_reservations

8732: , locator_id
8733: , lpn_id
8734: , primary_reservation_quantity - NVL(detailed_quantity, 0)
8735: , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8736: FROM mtl_reservations
8737: WHERE organization_id = g_rootinfos(l_root_id).organization_id
8738: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
8739: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
8740: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 8757: FROM mtl_reservations

8753: ,locator_id
8754: ,lpn_id
8755: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
8756: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8757: FROM mtl_reservations
8758: WHERE organization_id = g_rootinfos(l_root_id).organization_id
8759: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
8760: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
8761: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 8778: FROM mtl_reservations

8774: ,locator_id
8775: ,lpn_id
8776: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
8777: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8778: FROM mtl_reservations
8779: WHERE organization_id = g_rootinfos(l_root_id).organization_id
8780: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
8781: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
8782: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 8799: FROM mtl_reservations

8795: ,locator_id
8796: ,lpn_id
8797: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
8798: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8799: FROM mtl_reservations
8800: WHERE demand_source_line_id = g_demand_info(p_tree_id).demand_source_line_id
8801: AND NVL(organization_id, 0) = g_rootinfos(l_root_id).organization_id
8802: AND NVL(inventory_item_id,0) = g_rootinfos(l_root_id).inventory_item_id
8803: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id

Line 8821: FROM mtl_reservations

8817: ,locator_id
8818: ,lpn_id
8819: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
8820: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8821: FROM mtl_reservations
8822: WHERE organization_id = g_rootinfos(l_root_id).organization_id
8823: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
8824: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
8825: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 8843: FROM mtl_reservations

8839: ,locator_id
8840: ,lpn_id
8841: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
8842: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- invConv change
8843: FROM mtl_reservations
8844: WHERE organization_id = g_rootinfos(l_root_id).organization_id
8845: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
8846: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
8847: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id