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 300: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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

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

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

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 344: MTL_SYSTEM_ITEMS_KFV MTL

340: mtl.INVENTORY_ITEM_ID ,
341: mtl.organization_id ,
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'

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 391: from MTL_SYSTEM_ITEMS_KFV MTL

387: SELECT DISTINCT
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'

Line 503: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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

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

512: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
513: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
514: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
515:
516: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
517: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
518: IS
519: SELECT MTL.inventory_item_id,
520: MTL.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 726: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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

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

734: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
735: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
736: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
737:
738: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
739: IS
740: SELECT DISTINCT MI.inventory_item_id,
741: MI.organization_id,
742: MI.outside_operation_flag,

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 873: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

869: PROCEDURE validate_effectivity_item
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: )

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

880: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%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 ,

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 916: from MTL_SYSTEM_ITEMS_KFV MTL

912: SELECT DISTINCT
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

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 965: from MTL_SYSTEM_ITEMS_KFV MTL

961: /*SELECT DISTINCT
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'

Line 3718: from mtl_system_items_kfv kfv,

3714: from (select kfv.inventory_item_id,
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