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_SYSTEM_ITEMS

Line 102: msc_system_items msi ,

98: p_to_date IN DATE ) IS
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

Line 131: msc_system_items msi,

127: p_to_date IN DATE ) IS
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

Line 161: msc_system_items msi ,

157: p_to_date IN DATE ) IS
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

Line 191: msc_system_items msi ,

187: p_to_date IN DATE ) IS
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

Line 220: msc_system_items msi ,

216: p_to_date IN DATE ) IS
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

Line 254: msc_system_items msi ,

250: SELECT dem.demand_id transaction_id
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

Line 291: msc_system_items msi ,

287: SELECT dem.demand_id transaction_id
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

Line 421: msc_system_items i

417: p_to_date DATE) IS
418: SELECT supply_id
419: FROM msc_resource_requirements r,
420: msc_supplies s,
421: msc_system_items i
422: WHERE r.plan_id = p_plan_id
423: AND r.sr_instance_id = p_inst_id
424: AND r.organization_id = p_org_id
425: AND r.department_id = p_dept_id