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 INV_MATERIAL_STATUS_GRP

Line 2450: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

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,
2454: mtlt.lot_number,

Line 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),

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,
2523: mtlt.lot_number,

Line 2525: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

2521: mmtt.transfer_subinventory,
2522: mmtt.transfer_to_location,
2523: mtlt.lot_number,
2524: mmtt.lpn_id, mmtt.transaction_action_id,
2525: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
2526: mmtt.inventory_item_id,
2527: mmtt.subinventory_code,
2528: mmtt.locator_id,
2529: mtlt.lot_number,

Line 2652: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.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,
2656: mmtt.lot_number,

Line 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),

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,
2698: mmtt.lot_number,

Line 2700: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

2696: mmtt.transfer_subinventory,
2697: mmtt.transfer_to_location,
2698: mmtt.lot_number,
2699: mmtt.lpn_id, mmtt.transaction_action_id,
2700: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
2701: mmtt.inventory_item_id,
2702: mmtt.subinventory_code,
2703: mmtt.locator_id,
2704: mmtt.lot_number,

Line 3304: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

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,
3308: mtlt.lot_number,

Line 3338: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

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,
3342: mtlt.lot_number,

Line 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),

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,
3385: mtlt.lot_number,

Line 3387: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

3383: mmtt.transfer_subinventory,
3384: mmtt.transfer_to_location,
3385: mtlt.lot_number,
3386: mmtt.lpn_id, mmtt.transaction_action_id,
3387: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3388: mmtt.inventory_item_id,
3389: mmtt.subinventory_code,
3390: mmtt.locator_id,
3391: mtlt.lot_number,

Line 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),

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,
3427: mtlt.lot_number,

Line 3429: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

3425: mmtt.transfer_subinventory,
3426: mmtt.transfer_to_location,
3427: mtlt.lot_number,
3428: mmtt.lpn_id, mmtt.transaction_action_id,
3429: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3430: mmtt.inventory_item_id,
3431: mmtt.subinventory_code,
3432: mmtt.locator_id,
3433: mtlt.lot_number,

Line 3462: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

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,
3466: null,

Line 3488: WHERE mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

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,
3492: null,

Line 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),

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,
3526: null,

Line 3528: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

3524: mmtt.transfer_subinventory,
3525: mmtt.transfer_to_location,
3526: null,
3527: mmtt.lpn_id, mmtt.transaction_action_id,
3528: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3529: mmtt.inventory_item_id,
3530: mmtt.subinventory_code,
3531: mmtt.locator_id,
3532: null,

Line 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),

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,
3560: null,

Line 3562: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,

3558: mmtt.transfer_subinventory,
3559: mmtt.transfer_to_location,
3560: null,
3561: mmtt.lpn_id, mmtt.transaction_action_id,
3562: INV_MATERIAL_STATUS_GRP.get_default_status(mmtt.organization_id,
3563: mmtt.inventory_item_id,
3564: mmtt.subinventory_code,
3565: mmtt.locator_id,
3566: null,