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.AHL_RM_ROUTE_UTIL dependencies on MTL_PARAMETERS

Line 330: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

326: /*
327: SELECT DISTINCT MI.inventory_item_id,
328: MI.organization_id,
329: NVL(MI.inventory_item_flag,'X')
330: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
331: WHERE MP.organization_id = MI.organization_id
332: AND MI.concatenated_segments = c_item_number
333: AND MI.organization_id = c_inventory_org_id
334: AND MI.enabled_flag = 'Y'

Line 346: , MTL_PARAMETERS MP

342: NVL(mtl.inventory_item_flag,'X')
343: from
344: MTL_SYSTEM_ITEMS_KFV MTL
345: , fnd_lookup_values_vl IT
346: , MTL_PARAMETERS MP
347: where
348: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
349: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
350: and MTL.inventory_item_flag = 'Y'

Line 378: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

374: /*
375: SELECT DISTINCT MI.inventory_item_id,
376: MI.organization_id,
377: NVL(MI.inventory_item_flag,'X')
378: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
379: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
380: AND MP.organization_id = MI.organization_id
381: AND MI.inventory_item_id = c_inventory_item_id
382: AND MI.organization_id = c_inventory_org_id

Line 392: , MTL_PARAMETERS MP

388: mtl.INVENTORY_ITEM_ID ,
389: mtl.organization_id ,
390: NVL(mtl.inventory_item_flag,'X')
391: from MTL_SYSTEM_ITEMS_KFV MTL
392: , MTL_PARAMETERS MP
393: , fnd_lookup_values_vl IT
394: where
395: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
396: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 538: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

534: NVL(MI.inventory_item_flag,'X'),
535: NVL(MI.mtl_transactions_enabled_flag,'X'),
536: NVL(MI.stock_enabled_flag,'X'),
537: NVL(MI.wip_supply_type,0)
538: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
539: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
540: AND MP.master_organization_id = MI.organization_id
541: AND MI.concatenated_segments = c_item_number
542: --AND MI.organization_id = c_inventory_org_id

Line 589: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

585: NVL(MI.inventory_item_flag,'X'),
586: NVL(MI.mtl_transactions_enabled_flag,'X'),
587: NVL(MI.stock_enabled_flag,'X'),
588: NVL(MI.wip_supply_type,0)
589: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
590: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
591: AND MP.master_organization_id = MI.organization_id
592: AND MI.inventory_item_id = c_inventory_item_id
593: --AND MI.organization_id = c_inventory_org_id

Line 745: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

741: MI.organization_id,
742: MI.outside_operation_flag,
743: MI.purchasing_item_flag,
744: MI.purchasing_enabled_flag
745: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
746: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
747: AND MP.organization_id = MI.organization_id
748: AND MI.concatenated_segments = c_item_number
749: AND MI.enabled_flag = 'Y'

Line 761: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

757: MI.organization_id,
758: MI.outside_operation_flag,
759: MI.purchasing_item_flag,
760: MI.purchasing_enabled_flag
761: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
762: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
763: AND MP.organization_id = MI.organization_id
764: AND MI.inventory_item_id = c_inventory_item_id
765: AND MI.organization_id = c_inventory_org_id

Line 874: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,

870: (
871: x_return_status OUT NOCOPY VARCHAR2,
872: x_msg_data OUT NOCOPY VARCHAR2,
873: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
874: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
875: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
876: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
877: )
878: IS

Line 885: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)

881: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
882: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
883:
884: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
885: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)
886: IS
887: SELECT
888: MTL.INVENTORY_ITEM_ID ,
889: MTL.organization_id ,

Line 902: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

898: /*
899: SELECT DISTINCT MI.inventory_item_id,
900: MP.master_organization_id,
901: MI.comms_nl_trackable_flag
902: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
903: WHERE MP.master_organization_id = MI.organization_id
904: AND upper(MI.concatenated_segments) = upper(c_item_number)
905: AND MI.enabled_flag = 'Y'
906: AND upper(MP.ORGANIZATION_CODE)=upper(c_org_code)

Line 917: , MTL_PARAMETERS MP

913: mtl.INVENTORY_ITEM_ID ,
914: mtl.organization_id ,
915: mtl.comms_nl_trackable_flag
916: from MTL_SYSTEM_ITEMS_KFV MTL
917: , MTL_PARAMETERS MP
918: , MTL_PARAMETERS MP1
919: , fnd_lookup_values_vl IT
920: where
921: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 918: , MTL_PARAMETERS MP1

914: mtl.organization_id ,
915: mtl.comms_nl_trackable_flag
916: from MTL_SYSTEM_ITEMS_KFV MTL
917: , MTL_PARAMETERS MP
918: , MTL_PARAMETERS MP1
919: , fnd_lookup_values_vl IT
920: where
921: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
922: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 952: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

948: /*
949: SELECT DISTINCT MI.inventory_item_id,
950: MP.master_organization_id,
951: MI.comms_nl_trackable_flag
952: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
953: WHERE MP.master_organization_id = MI.organization_id
954: AND MI.inventory_item_id = c_inventory_item_id
955: AND MI.organization_id = c_inventory_org_id
956: AND MI.enabled_flag = 'Y'

Line 966: , MTL_PARAMETERS MP

962: mtl.INVENTORY_ITEM_ID ,
963: mtl.organization_id ,
964: mtl.comms_nl_trackable_flag
965: from MTL_SYSTEM_ITEMS_KFV MTL
966: , MTL_PARAMETERS MP
967: , fnd_lookup_values_vl IT
968: where
969: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
970: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 3719: mtl_parameters mp

3715: mp.master_organization_id inventory_org_id,
3716: mp.organization_code,
3717: kfv.concatenated_segments
3718: from mtl_system_items_kfv kfv,
3719: mtl_parameters mp
3720: where kfv.organization_id = mp.organization_id
3721: and exists (select 'X'
3722: from mtl_parameters mp1
3723: where mp1.master_organization_id = kfv.organization_id

Line 3722: from mtl_parameters mp1

3718: from mtl_system_items_kfv kfv,
3719: mtl_parameters mp
3720: where kfv.organization_id = mp.organization_id
3721: and exists (select 'X'
3722: from mtl_parameters mp1
3723: where mp1.master_organization_id = kfv.organization_id
3724: and mp1.eam_enabled_flag = 'Y')) mtl,
3725: (select inventory_item_id,
3726: inventory_org_id