DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on MTL_PARAMETERS

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 348: , MTL_PARAMETERS MP

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'
351: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
352: and MTL.inventory_item_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 394: , MTL_PARAMETERS MP

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'
398: AND MTL.ORGANIZATION_ID = MP.MASTER_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 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 880: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,

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: )
884: IS

Line 891: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%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 ,
895: MTL.organization_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 923: , MTL_PARAMETERS MP

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
927: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 924: , MTL_PARAMETERS MP1

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
927: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
928: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

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 972: , MTL_PARAMETERS MP

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'
976: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 4018: mtl_parameters mp

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
4022: where mp1.master_organization_id = kfv.organization_id

Line 4021: from mtl_parameters mp1

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
4022: where mp1.master_organization_id = kfv.organization_id
4023: and mp1.eam_enabled_flag = 'Y')) mtl,
4024: (select inventory_item_id,
4025: inventory_org_id