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 1001: , mtl_secondary_inventories sub '

997: , x.quantity_type, x.cost_group_id, x.lpn_id
998: , x.transaction_action_id , x.transfer_subinventory_code
999: , x.transfer_locator_id
1000: ) x
1001: , mtl_secondary_inventories sub '
1002: || l_lot_from || '
1003: WHERE
1004: x.organization_id = sub.organization_id (+)
1005: AND x.subinventory_code = sub.secondary_inventory_name (+) '

Line 2380: FROM mtl_secondary_inventories

2376: THEN
2377: l_reservable_type := g_is_sub_reservable(l_hash_value).reservable_type;
2378: ELSE
2379: SELECT reservable_type INTO l_reservable_type
2380: FROM mtl_secondary_inventories
2381: WHERE organization_id = p_organization_id
2382: AND secondary_inventory_name = p_subinventory_code;
2383: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;
2384: g_is_sub_reservable(l_hash_value).org_id := p_organization_id;

Line 2499: FROM mtl_secondary_inventories msinv

2495: /* DE-NORMALIZED MATERIAL STATUS */
2496: CURSOR is_RSV_subInv( org_id IN NUMBER
2497: , subinv IN VARCHAR2) IS
2498: SELECT NVL(msinv.reservable_type, 1)
2499: FROM mtl_secondary_inventories msinv
2500: WHERE msinv.organization_id = org_id
2501: AND msinv.secondary_inventory_name = subinv;
2502:
2503:

Line 2508: FROM mtl_secondary_inventories msinv

2504: /* NORMALIZED MATERIAL STATUS
2505: CURSOR is_RSV_subInv( org_id IN NUMBER
2506: , subinv IN VARCHAR2) IS
2507: SELECT '1'
2508: FROM mtl_secondary_inventories msinv
2509: WHERE msinv.status_id IN
2510: (SELECT mms.status_id
2511: FROM mtl_material_statuses mms
2512: WHERE NVL(mms.reservable_type, 1) = 1

Line 5315: , mtl_secondary_inventories sub

5311: , x.quantity_type, x.cost_group_id, x.lpn_id
5312: , x.transaction_action_id, x.transfer_subinventory_code
5313: , x.transfer_locator_id
5314: ) x
5315: , mtl_secondary_inventories sub
5316: WHERE
5317: x.organization_id = sub.organization_id (+)
5318: AND x.subinventory_code = sub.secondary_inventory_name (+)
5319: AND (l_asset_subs_only = 2 OR NVL(sub.asset_inventory,1) = 1)

Line 5546: , mtl_secondary_inventories sub

5542: , x.quantity_type, x.cost_group_id, x.lpn_id
5543: , x.transaction_action_id, x.transfer_subinventory_code
5544: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
5545: ) x
5546: , mtl_secondary_inventories sub
5547: , mtl_item_locations loc -- invConv change
5548: , mtl_parameters mp -- Onhand Material Status Support
5549: , mtl_material_statuses_b mms -- Onhand Material Status Support
5550: WHERE

Line 5871: , mtl_secondary_inventories sub

5867: , x.quantity_type, x.cost_group_id, x.lpn_id
5868: , x.transaction_action_id, x.transfer_subinventory_code
5869: , x.transfer_locator_id
5870: ) x
5871: , mtl_secondary_inventories sub
5872: , mtl_lot_numbers lot
5873: WHERE
5874: x.organization_id = sub.organization_id (+)
5875: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 6206: , mtl_secondary_inventories sub

6202: , x.quantity_type, x.cost_group_id, x.lpn_id
6203: , x.transaction_action_id, x.transfer_subinventory_code
6204: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6205: ) x
6206: , mtl_secondary_inventories sub
6207: , mtl_item_locations loc -- invConv change
6208: , mtl_lot_numbers lot
6209: , mtl_parameters mp -- Onhand Material Status Support
6210: , mtl_material_statuses_b mms -- Onhand Material Status Support

Line 6527: , mtl_secondary_inventories sub

6523: , x.quantity_type, x.cost_group_id, x.lpn_id
6524: , x.transaction_action_id, x.transfer_subinventory_code
6525: , x.transfer_locator_id
6526: ) x
6527: , mtl_secondary_inventories sub
6528: , mtl_lot_numbers lot
6529: WHERE
6530: x.organization_id = sub.organization_id (+)
6531: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 6861: , mtl_secondary_inventories sub

6857: , x.quantity_type, x.cost_group_id, x.lpn_id
6858: , x.transaction_action_id, x.transfer_subinventory_code
6859: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6860: ) x
6861: , mtl_secondary_inventories sub
6862: , mtl_item_locations loc -- invConv change
6863: , mtl_lot_numbers lot
6864: , mtl_parameters mp -- Onhand Material Status Support
6865: , mtl_material_statuses_b mms -- Onhand Material Status Support

Line 7190: , mtl_secondary_inventories sub

7186: , x.quantity_type, x.cost_group_id, x.lpn_id
7187: , x.transaction_action_id, x.transfer_subinventory_code
7188: , x.transfer_locator_id
7189: ) x
7190: , mtl_secondary_inventories sub
7191: WHERE
7192: x.organization_id = sub.organization_id (+)
7193: AND x.subinventory_code = sub.secondary_inventory_name (+)
7194: AND (l_asset_subs_only = 2 OR

Line 7603: , mtl_secondary_inventories sub

7599: , x.quantity_type, x.cost_group_id, x.lpn_id
7600: , x.transaction_action_id, x.transfer_subinventory_code
7601: , x.transfer_locator_id
7602: ) x
7603: , mtl_secondary_inventories sub
7604: , mtl_lot_numbers lot
7605: WHERE
7606: x.organization_id = sub.organization_id (+)
7607: AND x.subinventory_code = sub.secondary_inventory_name (+)

Line 8023: , mtl_secondary_inventories sub

8019: , x.quantity_type, x.cost_group_id, x.lpn_id
8020: , x.transaction_action_id, x.transfer_subinventory_code
8021: , x.transfer_locator_id
8022: ) x
8023: , mtl_secondary_inventories sub
8024: , mtl_lot_numbers lot
8025: WHERE
8026: x.organization_id = sub.organization_id (+)
8027: AND x.subinventory_code = sub.secondary_inventory_name (+)