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.EGO_MASS_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 128: FROM mtl_system_items_b msib2

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
128: FROM mtl_system_items_b msib2
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

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 138: FROM mtl_system_items_b msib2

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
138: FROM mtl_system_items_b msib2
139: WHERE msib2.organization_id = emit.organization_id
140: AND msib2.inventory_item_id = emit.inventory_item_id)
141: ), --PUOM
142: mp.cost_of_sales_account,

Line 160: FROM mtl_system_items_b msib

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
162: AND msib.inventory_item_id = emit.inventory_item_id)
163: AND emit.selected_flag = 'Y'
164: AND emot.org_selected_flag = 'Y'