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 4385: FROM mtl_reservations mr

4381: , lpn_id lpn_id
4382: , to_number(NULL) transaction_action_id
4383: , to_char(NULL) transfer_subinventory_code
4384: , to_number(NULL) transfer_locator_id
4385: FROM mtl_reservations mr
4386: WHERE
4387: Nvl(mr.supply_source_type_id, 13) = 13
4388: AND mr.primary_reservation_quantity > Nvl(mr.detailed_quantity,0)
4389: AND ((l_no_lpn_reservations <>1) OR (l_no_lpn_reservations = 1 AND mr.lpn_id IS NULL))

Line 4601: FROM mtl_reservations mr

4597: , to_number(NULL) transaction_action_id
4598: , to_char(NULL) transfer_subinventory_code
4599: , to_number(NULL) transfer_locator_id
4600: , to_number(NULL) status_id -- Onhand Material Status Support
4601: FROM mtl_reservations mr
4602: WHERE
4603: Nvl(mr.supply_source_type_id, 13) = 13
4604: AND mr.primary_reservation_quantity >
4605: Nvl(mr.detailed_quantity,0)

Line 4893: FROM mtl_reservations mr

4889: , lpn_id lpn_id
4890: , to_number(NULL) transaction_action_id
4891: , to_char(NULL) transfer_subinventory_code
4892: , to_number(NULL) transfer_locator_id
4893: FROM mtl_reservations mr
4894: WHERE
4895: Nvl(mr.supply_source_type_id, 13) = 13
4896: AND mr.primary_reservation_quantity >
4897: Nvl(mr.detailed_quantity,0)

Line 5238: FROM mtl_reservations mr

5234: , lpn_id lpn_id
5235: , to_number(NULL) transaction_action_id
5236: , to_char(NULL) transfer_subinventory_code
5237: , to_number(NULL) transfer_locator_id
5238: FROM mtl_reservations mr
5239: WHERE
5240: Nvl(mr.supply_source_type_id, 13) = 13
5241: AND mr.primary_reservation_quantity >
5242: Nvl(mr.detailed_quantity,0)

Line 5763: FROM mtl_reservations mr

5759: , lpn_id lpn_id
5760: , to_number(NULL) transaction_action_id
5761: , to_char(NULL) transfer_subinventory_code
5762: , to_number(NULL) transfer_locator_id
5763: FROM mtl_reservations mr
5764: WHERE
5765: Nvl(mr.supply_source_type_id, 13) = 13
5766: AND mr.primary_reservation_quantity >
5767: Nvl(mr.detailed_quantity,0)

Line 6081: FROM mtl_reservations mr

6077: , to_number(NULL) transaction_action_id
6078: , to_char(NULL) transfer_subinventory_code
6079: , to_number(NULL) transfer_locator_id
6080: , to_number(NULL) status_id -- Onhand Material Status Support
6081: FROM mtl_reservations mr
6082: WHERE
6083: Nvl(mr.supply_source_type_id, 13) = 13
6084: AND mr.primary_reservation_quantity >
6085: Nvl(mr.detailed_quantity,0)

Line 6533: FROM mtl_reservations mr

6529: , lpn_id lpn_id
6530: , to_number(NULL) transaction_action_id
6531: , to_char(NULL) transfer_subinventory_code
6532: , to_number(NULL) transfer_locator_id
6533: FROM mtl_reservations mr
6534: WHERE
6535: Nvl(mr.supply_source_type_id, 13) = 13
6536: AND mr.primary_reservation_quantity >
6537: Nvl(mr.detailed_quantity,0)

Line 6851: FROM mtl_reservations mr

6847: , to_number(NULL) transaction_action_id
6848: , to_char(NULL) transfer_subinventory_code
6849: , to_number(NULL) transfer_locator_id
6850: , to_number(NULL) status_id -- Onhand Material Status Support
6851: FROM mtl_reservations mr
6852: WHERE
6853: Nvl(mr.supply_source_type_id, 13) = 13
6854: AND mr.primary_reservation_quantity >
6855: Nvl(mr.detailed_quantity,0)

Line 7260: FROM mtl_reservations mr

7256: , lpn_id lpn_id
7257: , to_number(NULL) transaction_action_id
7258: , to_char(NULL) transfer_subinventory_code
7259: , to_number(NULL) transfer_locator_id
7260: FROM mtl_reservations mr
7261: WHERE
7262: Nvl(mr.supply_source_type_id, 13) = 13
7263: AND mr.primary_reservation_quantity > Nvl(mr.detailed_quantity,0)
7264: AND ((l_no_lpn_reservations <>1)

Line 7562: FROM mtl_reservations mr

7558: , lpn_id lpn_id
7559: , to_number(NULL) transaction_action_id
7560: , to_char(NULL) transfer_subinventory_code
7561: , to_number(NULL) transfer_locator_id
7562: FROM mtl_reservations mr
7563: WHERE
7564: Nvl(mr.supply_source_type_id, 13) = 13
7565: AND mr.primary_reservation_quantity >
7566: Nvl(mr.detailed_quantity,0)

Line 8018: FROM mtl_reservations mr

8014: , lpn_id lpn_id
8015: , to_number(NULL) transaction_action_id
8016: , to_char(NULL) transfer_subinventory_code
8017: , to_number(NULL) transfer_locator_id
8018: FROM mtl_reservations mr
8019: WHERE
8020: Nvl(mr.supply_source_type_id, 13) = 13
8021: AND mr.primary_reservation_quantity >
8022: Nvl(mr.detailed_quantity,0)

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

9057:
9058: --add_demand_qty
9059: -- When in transaction_mode, this procedure will fix
9060: -- the quantity tree to reflect the correct available quantities.
9061: -- To do this, it queries the mtl_reservations table to find
9062: -- reservations which correspond to the demand info. For each
9063: -- reservation, it calls add_quantities to subtract those reservations
9064: -- from the quantity tree (since that quantity should be available
9065: -- for this transaction). We call add_quantities with a negative

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

9088: l_mult NUMBER := -1;
9089:
9090:
9091: --We need 6 possible queries to improve performance and make best
9092: -- use of the indices on mtl_reservations, while avoid dynamic sql.
9093:
9094: -- demand line is not NULL, not pick release
9095: -- Bug 4494038: exclude crossdock reservations
9096: CURSOR c_demand_dl IS

Line 9104: FROM mtl_reservations

9100: , locator_id
9101: , lpn_id
9102: , primary_reservation_quantity - NVL(detailed_quantity, 0)
9103: , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9104: FROM mtl_reservations
9105: WHERE organization_id = g_rootinfos(l_root_id).organization_id
9106: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
9107: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
9108: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 9125: FROM mtl_reservations

9121: ,locator_id
9122: ,lpn_id
9123: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
9124: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9125: FROM mtl_reservations
9126: WHERE organization_id = g_rootinfos(l_root_id).organization_id
9127: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
9128: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
9129: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 9146: FROM mtl_reservations

9142: ,locator_id
9143: ,lpn_id
9144: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
9145: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9146: FROM mtl_reservations
9147: WHERE organization_id = g_rootinfos(l_root_id).organization_id
9148: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
9149: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
9150: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 9167: FROM mtl_reservations

9163: ,locator_id
9164: ,lpn_id
9165: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
9166: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9167: FROM mtl_reservations
9168: WHERE demand_source_line_id = g_demand_info(p_tree_id).demand_source_line_id
9169: AND NVL(organization_id, 0) = g_rootinfos(l_root_id).organization_id
9170: AND NVL(inventory_item_id,0) = g_rootinfos(l_root_id).inventory_item_id
9171: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id

Line 9189: FROM mtl_reservations

9185: ,locator_id
9186: ,lpn_id
9187: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
9188: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9189: FROM mtl_reservations
9190: WHERE organization_id = g_rootinfos(l_root_id).organization_id
9191: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
9192: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
9193: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id

Line 9211: FROM mtl_reservations

9207: ,locator_id
9208: ,lpn_id
9209: ,primary_reservation_quantity - NVL(detailed_quantity, 0)
9210: ,NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0)
9211: FROM mtl_reservations
9212: WHERE organization_id = g_rootinfos(l_root_id).organization_id
9213: AND inventory_item_id = g_rootinfos(l_root_id).inventory_item_id
9214: AND demand_source_type_id = g_demand_info(p_tree_id).demand_source_type_id
9215: AND demand_source_header_id = g_demand_info(p_tree_id).demand_source_header_id