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_CONSIGNED_VALIDATIONS dependencies on MTL_ITEM_LOCATIONS

Line 1232: FROM mtl_item_locations mil

1228: --SELECT TO_NUMBER(NVL(attribute1, '0'))
1229: CURSOR is_RSV_loct( org_id IN NUMBER
1230: , loct_id IN NUMBER) IS
1231: SELECT '1'
1232: FROM mtl_item_locations mil
1233: WHERE mil.status_id IN
1234: (SELECT mms.status_id
1235: FROM mtl_material_statuses mms
1236: WHERE NVL(mms.attribute1, '1') = '1'

Line 2335: EXISTS (SELECT 'x' FROM mtl_item_locations mil

2331: AND nvl(mln.availability_type,2) = decode(p_include_nonnet,1,nvl(mln.availability_type,2),1)
2332: AND trunc(nvl(nvl(mtlt.lot_expiration_date,mln.expiration_Date),SYSDATE+1))> trunc(sysdate))
2333: AND (mmtt.locator_id IS NULL OR
2334: (mmtt.locator_id IS NOT NULL AND
2335: EXISTS (SELECT 'x' FROM mtl_item_locations mil
2336: WHERE mmtt.organization_id = mil.organization_id
2337: AND mmtt.locator_id = mil.inventory_location_id
2338: AND mmtt.subinventory_code = mil.subinventory_code
2339: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1))))

Line 2395: SELECT 'x' FROM mtl_item_locations mil

2391: (
2392: mmtt.transfer_to_location IS NOT NULL AND
2393: EXISTS
2394: (
2395: SELECT 'x' FROM mtl_item_locations mil
2396: WHERE decode(mmtt.transaction_action_id,
2397: 3, mmtt.transfer_organization,mmtt.organization_id) = mil.organization_id
2398: AND mmtt.transfer_to_location = mil.inventory_location_id
2399: AND mmtt.transfer_subinventory = mil.subinventory_code

Line 2445: EXISTS (SELECT 'x' FROM mtl_item_locations mil

2441: AND p_item_id = mln.inventory_item_id(+)
2442: AND trunc(nvl(nvl(mtlt.lot_expiration_date,mln.expiration_Date),SYSDATE+1))> trunc(sysdate))
2443: AND (mmtt.locator_id IS NULL OR
2444: (mmtt.locator_id IS NOT NULL AND
2445: EXISTS (SELECT 'x' FROM mtl_item_locations mil
2446: WHERE mmtt.organization_id = mil.organization_id
2447: AND mmtt.locator_id = mil.inventory_location_id
2448: AND mmtt.subinventory_code = mil.subinventory_code)))
2449: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

Line 2510: SELECT 'x' FROM mtl_item_locations mil

2506: (
2507: mmtt.transfer_to_location IS NOT NULL AND
2508: EXISTS
2509: (
2510: SELECT 'x' FROM mtl_item_locations mil
2511: WHERE decode(mmtt.transaction_action_id,
2512: 3, mmtt.transfer_organization,mmtt.organization_id) = mil.organization_id
2513: AND mmtt.transfer_to_location = mil.inventory_location_id
2514: AND mmtt.transfer_subinventory = mil.subinventory_code

Line 2569: EXISTS (select 'x' from mtl_item_locations mil

2565:
2566: /* nsinghi MIN-MAX INVCONV start */
2567: AND (mmtt.locator_id IS NULL OR
2568: (mmtt.locator_id IS NOT NULL AND
2569: EXISTS (select 'x' from mtl_item_locations mil
2570: WHERE mmtt.organization_id = mil.organization_id
2571: AND mmtt.locator_id = mil.inventory_location_id
2572: AND mmtt.subinventory_code = mil.subinventory_code
2573: AND mil.availability_type = decode(p_include_nonnet,1,mil.availability_type,1))))

Line 2605: EXISTS (select 'x' from mtl_item_locations mil

2601:
2602: /* nsinghi MIN-MAX INVCONV start */
2603: AND (mmtt.transfer_to_location IS NULL OR
2604: (mmtt.transfer_to_location IS NOT NULL AND
2605: EXISTS (select 'x' from mtl_item_locations mil
2606: WHERE decode(mmtt.transaction_action_id,
2607: 3, mmtt.transfer_organization,mmtt.organization_id) = mil.organization_id
2608: AND mmtt.transfer_to_location = mil.inventory_location_id
2609: AND mmtt.transfer_subinventory = mil.subinventory_code

Line 2646: EXISTS (select 'x' from mtl_item_locations mil

2642:
2643: /* nsinghi MIN-MAX INVCONV start */
2644: AND (mmtt.locator_id IS NULL OR
2645: (mmtt.locator_id IS NOT NULL AND
2646: EXISTS (select 'x' from mtl_item_locations mil
2647: WHERE mmtt.organization_id = mil.organization_id
2648: AND mmtt.locator_id = mil.inventory_location_id
2649: AND mmtt.subinventory_code = mil.subinventory_code)))
2650: /* nsinghi MIN-MAX INVCONV end */

Line 2687: EXISTS (select 'x' from mtl_item_locations mil

2683:
2684: /* nsinghi MIN-MAX INVCONV start */
2685: AND (mmtt.transfer_to_location IS NULL OR
2686: (mmtt.transfer_to_location IS NOT NULL AND
2687: EXISTS (select 'x' from mtl_item_locations mil
2688: WHERE decode(mmtt.transaction_action_id,
2689: 3, mmtt.transfer_organization,mmtt.organization_id) = mil.organization_id
2690: AND mmtt.transfer_to_location = mil.inventory_location_id
2691: AND mmtt.transfer_subinventory = mil.subinventory_code)))