APPS.AHL_FMP_COMMON_PVT dependencies on MTL_PARAMETERS

Line 134: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

130: MI.wip_supply_type,
131: MI.eam_item_type,
132: MI.comms_nl_trackable_flag,
133: MI.serv_req_enabled_code
134: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
135: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
136: AND MP.organization_id = MI.organization_id
137: AND MI.concatenated_segments = c_item_number
138: AND MI.enabled_flag = 'Y'

Line 154: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

150: MI.wip_supply_type,
151: MI.eam_item_type,
152: MI.comms_nl_trackable_flag,
153: MI.serv_req_enabled_code
154: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
155: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
156: AND MP.organization_id = MI.organization_id
157: AND MI.inventory_item_id = c_inventory_item_id
158: AND MI.enabled_flag = 'Y'

Line 1029: mtl_parameters m

1025: and b.manufacturer_name = c_manufacturer_name
1026: and a.organization_id in ( select distinct
1027: m.master_organization_id
1028: from inv_organization_info_v org,
1029: mtl_parameters m
1030: where org.organization_id = m.organization_id
1031: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1032:
1033:

Line 1052: mtl_parameters m

1048: where manufacturer_id = c_manufacturer_id
1049: and organization_id in ( select distinct
1050: m.master_organization_id
1051: from inv_organization_info_v org,
1052: mtl_parameters m
1053: where org.organization_id = m.organization_id
1054: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1055:
1056: