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.MSC_PQ_UTILS dependencies on MSC_ITEM_CATEGORIES

Line 103: msc_item_categories mic

99: SELECT sup.transaction_id
100: --,sup.new_schedule_date new_due_date
101: FROM msc_supplies sup,
102: msc_system_items msi ,
103: msc_item_categories mic
104: WHERE mic.sr_instance_id = sup.sr_instance_id
105: AND mic.organization_id = sup.organization_id
106: AND mic.inventory_item_id = sup.inventory_item_id
107: AND

Line 132: msc_item_categories mic

128: SELECT dem.demand_id transaction_id
129: --,dem.using_assembly_demand_date new_due_date
130: FROM msc_demands dem,
131: msc_system_items msi,
132: msc_item_categories mic
133: WHERE mic.sr_instance_id = dem.sr_instance_id
134: AND mic.organization_id = dem.organization_id
135: AND mic.inventory_item_id = dem.inventory_item_id
136: AND

Line 162: msc_item_categories mic

158: SELECT mso.demand_id transaction_id
159: --,mso.requirement_date new_due_date
160: FROM msc_sales_orders mso,
161: msc_system_items msi ,
162: msc_item_categories mic
163: WHERE mso.sr_instance_id = mic.sr_instance_id
164: AND mso.inventory_item_id = mic.inventory_item_id
165: AND mso.organization_id = mic.organization_id
166: AND

Line 192: msc_item_categories mic

188: SELECT jro.transaction_id
189: --,jro.reco_date_required new_due_date
190: FROM msc_job_requirement_ops jro,
191: msc_system_items msi ,
192: msc_item_categories mic
193: WHERE mic.sr_instance_id = jro.sr_instance_id
194: AND mic.organization_id = jro.organization_id
195: AND mic.inventory_item_id = jro.component_item_id
196: --AND jro.plan_id = -1

Line 221: msc_item_categories mic,

217: SELECT sup.transaction_id
218: --,nvl(sup.new_ship_date,sup.new_schedule_date) new_due_date
219: FROM msc_supplies sup,
220: msc_system_items msi ,
221: msc_item_categories mic,
222: msc_plans mp
223: WHERE mic.sr_instance_id = sup.sr_instance_id
224: AND mic.organization_id = sup.organization_id
225: AND mic.inventory_item_id = sup.inventory_item_id

Line 255: msc_item_categories mic

251: --,nvl(dem.planned_inbound_due_date , dem.using_assembly_demand_date) new_due_date
252: FROM msc_demands dem,
253: msc_plans mp,
254: msc_system_items msi ,
255: msc_item_categories mic
256: WHERE mic.sr_instance_id = dem.sr_instance_id
257: AND mic.organization_id = dem.organization_id
258: AND mic.inventory_item_id = dem.inventory_item_id
259: AND

Line 292: msc_item_categories mic

288: --,nvl(dem.old_using_assembly_demand_date , dem.using_assembly_demand_date) new_due_date
289: FROM msc_demands dem,
290: msc_plans mp,
291: msc_system_items msi ,
292: msc_item_categories mic
293: WHERE mic.sr_instance_id = dem.sr_instance_id
294: AND mic.organization_id = dem.organization_id
295: AND mic.inventory_item_id = dem.inventory_item_id
296: AND