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_SYSTEM_ITEMS_KFV

Line 302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

298: PROCEDURE validate_adt_item
299: (
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
303: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
305: )
306: IS

Line 312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
314: IS
315: --AMSRINIV. Bug 4913429. Doing away with the use of 'upper' to tune below query.
316: SELECT

Line 332: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

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

Line 346: MTL_SYSTEM_ITEMS_KFV MTL

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

Line 380: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

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

Line 393: from MTL_SYSTEM_ITEMS_KFV MTL

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

Line 505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

501: PROCEDURE validate_item
502: (
503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_data OUT NOCOPY VARCHAR2,
505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
506: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
508: )
509: IS

Line 518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
520: IS
521: SELECT DISTINCT MTL.inventory_item_id,
522: MTL.organization_id,

Line 540: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

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

Line 591: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

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

Line 729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

725: PROCEDURE validate_service_item
726: (
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
730: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
732: )
733: IS

Line 742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )

738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:
741: -- STHILAK -changed for bug# 9503666 - begin
742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
743: IS
744: SELECT DISTINCT MI.inventory_item_id,
745: mast.organization_id,
746: MI.outside_operation_flag,

Line 749: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI,mtl_system_items_b mast

745: mast.organization_id,
746: MI.outside_operation_flag,
747: MI.purchasing_item_flag,
748: MI.purchasing_enabled_flag
749: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI,mtl_system_items_b mast
750: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
751: AND MP.organization_id = MI.organization_id
752: AND MP.master_organization_id = mast.organization_id
753: AND MI.concatenated_segments = c_item_number

Line 767: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

763: MI.organization_id,
764: MI.outside_operation_flag,
765: MI.purchasing_item_flag,
766: MI.purchasing_enabled_flag
767: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
768: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
769: AND MP.organization_id = MI.organization_id
770: AND MI.inventory_item_id = c_inventory_item_id
771: AND MI.organization_id = c_inventory_org_id

Line 879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

875: PROCEDURE validate_effectivity_item
876: (
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
880: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
881: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
883: )

Line 890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
889:
890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
891: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)
892: IS
893: SELECT
894: MTL.INVENTORY_ITEM_ID ,

Line 908: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

904: /*
905: SELECT DISTINCT MI.inventory_item_id,
906: MP.master_organization_id,
907: MI.comms_nl_trackable_flag
908: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
909: WHERE MP.master_organization_id = MI.organization_id
910: AND upper(MI.concatenated_segments) = upper(c_item_number)
911: AND MI.enabled_flag = 'Y'
912: AND upper(MP.ORGANIZATION_CODE)=upper(c_org_code)

Line 922: from MTL_SYSTEM_ITEMS_KFV MTL

918: SELECT DISTINCT
919: mtl.INVENTORY_ITEM_ID ,
920: mtl.organization_id ,
921: mtl.comms_nl_trackable_flag
922: from MTL_SYSTEM_ITEMS_KFV MTL
923: , MTL_PARAMETERS MP
924: , MTL_PARAMETERS MP1
925: , fnd_lookup_values_vl IT
926: where

Line 958: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

954: /*
955: SELECT DISTINCT MI.inventory_item_id,
956: MP.master_organization_id,
957: MI.comms_nl_trackable_flag
958: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
959: WHERE MP.master_organization_id = MI.organization_id
960: AND MI.inventory_item_id = c_inventory_item_id
961: AND MI.organization_id = c_inventory_org_id
962: AND MI.enabled_flag = 'Y'

Line 971: from MTL_SYSTEM_ITEMS_KFV MTL

967: /*SELECT DISTINCT
968: mtl.INVENTORY_ITEM_ID ,
969: mtl.organization_id ,
970: mtl.comms_nl_trackable_flag
971: from MTL_SYSTEM_ITEMS_KFV MTL
972: , MTL_PARAMETERS MP
973: , fnd_lookup_values_vl IT
974: where
975: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 4017: from mtl_system_items_kfv kfv,

4013: from (select kfv.inventory_item_id,
4014: mp.master_organization_id inventory_org_id,
4015: mp.organization_code,
4016: kfv.concatenated_segments
4017: from mtl_system_items_kfv kfv,
4018: mtl_parameters mp
4019: where kfv.organization_id = mp.organization_id
4020: and exists (select 'X'
4021: from mtl_parameters mp1