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_SECONDARY_INVENTORIES

Line 642: FROM mtl_secondary_inventories

638: print_debug('In check_is_reservable_sub, getting the cache value');
639: l_reservable_type := g_is_sub_reservable(l_hash_value).reservable_type;
640: ELSE
641: SELECT Nvl(reservable_type,1) INTO l_reservable_type
642: FROM mtl_secondary_inventories
643: WHERE organization_id = p_organization_id
644: AND secondary_inventory_name = p_subinventory_code;
645: print_debug('In check_is_reservable_sub, Query fired');
646: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;

Line 1019: FROM mtl_secondary_inventories msinv

1015:
1016: CURSOR is_RSV_subInv( org_id IN NUMBER
1017: , subinv IN VARCHAR2) IS
1018: SELECT NVL(msinv.reservable_type, 1)
1019: FROM mtl_secondary_inventories msinv
1020: WHERE msinv.organization_id = org_id
1021: AND msinv.secondary_inventory_name = subinv;
1022:
1023:

Line 4518: , mtl_secondary_inventories sub

4514: , x.quantity_type, x.cost_group_id, x.lpn_id
4515: , x.transaction_action_id, x.transfer_subinventory_code
4516: , x.transfer_locator_id
4517: ) x
4518: , mtl_secondary_inventories sub
4519: WHERE
4520: x.organization_id = sub.organization_id (+)
4521: AND x.subinventory_code = sub.secondary_inventory_name (+)
4522: AND (l_asset_subs_only = 2 OR NVL(sub.asset_inventory,1) = 1)

Line 4769: , mtl_secondary_inventories sub

4765: , x.quantity_type, x.cost_group_id, x.lpn_id
4766: , x.transaction_action_id, x.transfer_subinventory_code
4767: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
4768: ) x
4769: , mtl_secondary_inventories sub
4770: , mtl_item_locations loc
4771: , mtl_parameters mp -- Onhand Material Status Support
4772: , mtl_material_statuses_b mms -- Onhand Material Status Support
4773: WHERE

Line 5159: , mtl_secondary_inventories sub

5155: , x.quantity_type, x.cost_group_id, x.lpn_id
5156: , x.transaction_action_id, x.transfer_subinventory_code
5157: , x.transfer_locator_id
5158: ) x
5159: , mtl_secondary_inventories sub
5160: , mtl_lot_numbers lot
5161: WHERE
5162: x.organization_id = sub.organization_id (+)
5163: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 5680: , mtl_secondary_inventories sub

5676: , x.quantity_type, x.cost_group_id, x.lpn_id
5677: , x.transaction_action_id, x.transfer_subinventory_code
5678: , x.transfer_locator_id
5679: ) x
5680: , mtl_secondary_inventories sub
5681: , mtl_lot_numbers lot
5682: WHERE
5683: x.organization_id = sub.organization_id (+)
5684: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 5999: , mtl_secondary_inventories sub

5995: , x.quantity_type, x.cost_group_id, x.lpn_id
5996: , x.transaction_action_id, x.transfer_subinventory_code
5997: , x.transfer_locator_id
5998: ) x
5999: , mtl_secondary_inventories sub
6000: , mtl_lot_numbers lot
6001: WHERE
6002: x.organization_id = sub.organization_id (+)
6003: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 6411: , mtl_secondary_inventories sub

6407: , x.quantity_type, x.cost_group_id, x.lpn_id
6408: , x.transaction_action_id, x.transfer_subinventory_code
6409: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6410: ) x
6411: , mtl_secondary_inventories sub
6412: , mtl_item_locations loc
6413: , mtl_lot_numbers lot
6414: , mtl_parameters mp -- Onhand Material Status Support
6415: , mtl_material_statuses_b mms -- Onhand Material Status Support

Line 6768: , mtl_secondary_inventories sub

6764: , x.quantity_type, x.cost_group_id, x.lpn_id
6765: , x.transaction_action_id, x.transfer_subinventory_code
6766: , x.transfer_locator_id
6767: ) x
6768: , mtl_secondary_inventories sub
6769: , mtl_lot_numbers lot
6770: WHERE
6771: x.organization_id = sub.organization_id (+)
6772: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 7139: , mtl_secondary_inventories sub

7135: , x.quantity_type, x.cost_group_id, x.lpn_id
7136: , x.transaction_action_id, x.transfer_subinventory_code
7137: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
7138: ) x
7139: , mtl_secondary_inventories sub
7140: , mtl_item_locations loc
7141: , mtl_lot_numbers lot
7142: , mtl_parameters mp -- Onhand Material Status Support
7143: , mtl_material_statuses_b mms -- Onhand Material Status Support

Line 7485: , mtl_secondary_inventories sub

7481: , x.quantity_type, x.cost_group_id, x.lpn_id
7482: , x.transaction_action_id, x.transfer_subinventory_code
7483: , x.transfer_locator_id
7484: ) x
7485: , mtl_secondary_inventories sub
7486: WHERE
7487: x.organization_id = sub.organization_id (+)
7488: AND x.subinventory_code = sub.secondary_inventory_name (+)
7489: AND (l_asset_subs_only = 2 OR

Line 7937: , mtl_secondary_inventories sub

7933: , x.quantity_type, x.cost_group_id, x.lpn_id
7934: , x.transaction_action_id, x.transfer_subinventory_code
7935: , x.transfer_locator_id
7936: ) x
7937: , mtl_secondary_inventories sub
7938: , mtl_lot_numbers lot
7939: WHERE
7940: x.organization_id = sub.organization_id (+)
7941: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 8393: , mtl_secondary_inventories sub

8389: , x.quantity_type, x.cost_group_id, x.lpn_id
8390: , x.transaction_action_id, x.transfer_subinventory_code
8391: , x.transfer_locator_id
8392: ) x
8393: , mtl_secondary_inventories sub
8394: , mtl_lot_numbers lot
8395: WHERE
8396: x.organization_id = sub.organization_id (+)
8397: AND x.subinventory_code = sub.secondary_inventory_name (+)