APPS.AHL_FMP_COMMON_PVT dependencies on MTL_PARAMETERS

Line 143: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

139: MI.wip_supply_type,
140: MI.eam_item_type,
141: MI.comms_nl_trackable_flag,
142: MI.serv_req_enabled_code
143: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
144: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
145: AND MP.organization_id = MI.organization_id
146: AND MI.concatenated_segments = c_item_number
147: AND MI.enabled_flag = 'Y'

Line 163: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

159: MI.wip_supply_type,
160: MI.eam_item_type,
161: MI.comms_nl_trackable_flag,
162: MI.serv_req_enabled_code
163: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
164: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
165: AND MP.organization_id = MI.organization_id
166: AND MI.inventory_item_id = c_inventory_item_id
167: AND MI.enabled_flag = 'Y'

Line 1040: mtl_parameters m

1036: and b.manufacturer_name = c_manufacturer_name
1037: and a.organization_id in ( select distinct
1038: m.master_organization_id
1039: from inv_organization_info_v org,
1040: mtl_parameters m
1041: where org.organization_id = m.organization_id
1042: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1043:
1044:

Line 1063: mtl_parameters m

1059: where manufacturer_id = c_manufacturer_id
1060: and organization_id in ( select distinct
1061: m.master_organization_id
1062: from inv_organization_info_v org,
1063: mtl_parameters m
1064: where org.organization_id = m.organization_id
1065: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1066:
1067: