APPS.EGO_MASS_UPDATE_PVT dependencies on MTL_PARAMETERS

Line 123: FROM mtl_system_items_b msib, mtl_parameters mp

119: emit.item_number,
120: emit.description,
121: emot.organization_id_child, --ORG_ID
122: NVL( (SELECT msib.primary_uom_code
123: FROM mtl_system_items_b msib, mtl_parameters mp
124: WHERE msib.organization_id = mp.master_organization_id
125: AND mp.organization_id = emot.organization_id_child
126: AND msib.inventory_item_id = emit.inventory_item_id),
127: (SELECT msib2.primary_uom_code

Line 133: FROM mtl_system_items_b msib, mtl_parameters mp

129: WHERE msib2.organization_id = emit.organization_id
130: AND msib2.inventory_item_id = emit.inventory_item_id)
131: ) UOM_CODE,
132: NVL( (SELECT msib.primary_unit_of_measure -- Can We avoid this second select
133: FROM mtl_system_items_b msib, mtl_parameters mp
134: WHERE msib.organization_id = mp.master_organization_id
135: AND mp.organization_id = emot.organization_id_child
136: AND msib.inventory_item_id = emit.inventory_item_id),
137: (SELECT msib2.primary_unit_of_measure

Line 157: mtl_parameters mp

153: FND_GLOBAL.conc_program_id,
154: SYSDATE
155: FROM ego_massupdate_item_tmp emit,
156: ego_massupdate_org_tmp emot,
157: mtl_parameters mp
158: WHERE NOT EXISTS
159: (SELECT '1'
160: FROM mtl_system_items_b msib
161: WHERE msib.organization_id = emot.organization_id_child

Line 252: mtl_parameters mp

248: , FND_GLOBAL.prog_appl_id
249: , FND_GLOBAL.conc_program_id
250: , SYSDATE
251: FROM mtl_system_items_interface msii,
252: mtl_parameters mp
253: WHERE msii.set_process_id = l_set_process_id
254: AND mp.organization_id = msii.organization_id;
255:
256: */