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_MATERIAL_STATUSES

Line 1235: FROM mtl_material_statuses mms

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'
1237: AND mms.locator_control = 1)
1238: AND mil.organization_id = org_id
1239: AND mil.inventory_location_id = loct_id;

Line 1249: FROM mtl_material_statuses mms

1245: SELECT '1'
1246: FROM mtl_lot_numbers mln
1247: WHERE mln.status_id IN
1248: (SELECT mms.status_id
1249: FROM mtl_material_statuses mms
1250: WHERE NVL(mms.attribute1, '1') = '1'
1251: AND mms.lot_control = 1)
1252: AND mln.inventory_item_id = item_id
1253: AND mln.organization_id = org_id

Line 2449: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

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
2450: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
2451: mmtt.inventory_item_id,
2452: mmtt.subinventory_code,
2453: mmtt.locator_id,

Line 2518: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

2514: AND mmtt.transfer_subinventory = mil.subinventory_code
2515: )
2516: )
2517: )
2518: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
2519: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
2520: mmtt.inventory_item_id,
2521: mmtt.transfer_subinventory,
2522: mmtt.transfer_to_location,

Line 2651: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

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 */
2651: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
2652: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
2653: mmtt.inventory_item_id,
2654: mmtt.subinventory_code,
2655: mmtt.locator_id,

Line 2693: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

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)))
2692: /* nsinghi MIN-MAX INVCONV end */
2693: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
2694: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
2695: mmtt.inventory_item_id,
2696: mmtt.transfer_subinventory,
2697: mmtt.transfer_to_location,

Line 3238: AND EXISTS (SELECT 1 FROM mtl_material_statuses mms

3234: AND moq.inventory_item_id = mln.inventory_item_id(+)
3235: AND trunc(nvl(mln.expiration_date, sysdate+1)) > trunc(sysdate)
3236: AND nvl(moq.planning_tp_type,2) = 2
3237: AND ((moq.status_id IS NOT NULL
3238: AND EXISTS (SELECT 1 FROM mtl_material_statuses mms
3239: WHERE status_id = moq.status_id
3240: and mms.inventory_atp_code = 1
3241: )
3242: )

Line 3263: AND EXISTS (SELECT 1 FROM mtl_material_statuses mms

3259: AND moq.inventory_item_id = mln.inventory_item_id(+)
3260: AND trunc(nvl(mln.expiration_date, sysdate+1)) > trunc(sysdate)
3261: AND nvl(moq.planning_tp_type,2) = 2
3262: AND ((moq.status_id IS NOT NULL
3263: AND EXISTS (SELECT 1 FROM mtl_material_statuses mms
3264: WHERE status_id = moq.status_id
3265: and mms.availability_type = decode(p_onhand_source,g_all_subs,mms.availability_type,1)
3266: )
3267: )

Line 3303: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3299: AND mtlt.lot_number = mln.lot_number(+)
3300: AND p_org_id = mln.organization_id(+)
3301: AND p_item_id = mln.inventory_item_id(+)
3302: AND trunc(nvl(nvl(mtlt.lot_expiration_date,mln.expiration_Date),sysdate+1))> trunc(sysdate))
3303: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3304: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3305: mmtt.inventory_item_id,
3306: mmtt.subinventory_code,
3307: mmtt.locator_id,

Line 3337: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3333: AND mtlt.lot_number = mln.lot_number(+)
3334: AND p_org_id = mln.organization_id(+)
3335: AND p_item_id = mln.inventory_item_id(+)
3336: AND trunc(nvl(nvl(mtlt.lot_expiration_date,mln.expiration_Date),sysdate+1))> trunc(sysdate))
3337: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3338: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3339: mmtt.inventory_item_id,
3340: mmtt.subinventory_code,
3341: mmtt.locator_id,

Line 3380: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3376: AND decode(mmtt.transaction_action_id,
3377: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)
3378: AND p_item_id = mln.inventory_item_id(+)
3379: AND trunc(nvl(nvl(mtlt.lot_expiration_Date,mln.expiration_date),sysdate+1))> trunc(sysdate))
3380: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3381: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
3382: mmtt.inventory_item_id,
3383: mmtt.transfer_subinventory,
3384: mmtt.transfer_to_location,

Line 3422: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3418: AND decode(mmtt.transaction_action_id,
3419: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)
3420: AND p_item_id = mln.inventory_item_id(+)
3421: AND trunc(nvl(nvl(mtlt.lot_expiration_Date,mln.expiration_date),sysdate+1))> trunc(sysdate))
3422: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3423: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
3424: mmtt.inventory_item_id,
3425: mmtt.transfer_subinventory,
3426: mmtt.transfer_to_location,

Line 3461: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3457: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3458: WHERE msi.organization_id = mmtt.organization_id
3459: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3460: AND mmtt.planning_organization_id IS NULL
3461: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3462: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3463: mmtt.inventory_item_id,
3464: mmtt.subinventory_code,
3465: mmtt.locator_id,

Line 3487: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3483: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3484: WHERE msi.organization_id = mmtt.organization_id
3485: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3486: AND mmtt.planning_organization_id IS NULL
3487: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3488: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3489: mmtt.inventory_item_id,
3490: mmtt.subinventory_code,
3491: mmtt.locator_id,

Line 3521: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3517: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3518: 3, mmtt.transfer_organization,mmtt.organization_id)
3519: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
3520: AND mmtt.planning_organization_id IS NULL
3521: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3522: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
3523: mmtt.inventory_item_id,
3524: mmtt.transfer_subinventory,
3525: mmtt.transfer_to_location,

Line 3555: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

3551: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3552: 3, mmtt.transfer_organization,mmtt.organization_id)
3553: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
3554: AND mmtt.planning_organization_id IS NULL
3555: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms
3556: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(decode(mmtt.transaction_action_id,3, mmtt.transfer_organization,mmtt.organization_id),
3557: mmtt.inventory_item_id,
3558: mmtt.transfer_subinventory,
3559: mmtt.transfer_to_location,