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_SUPPLY_PKG dependencies on MSC_SYSTEM_ITEMS

Line 100: msc_system_items msi

96: msi.organization_id,
97: msi.inventory_item_id,
98: nvl(mis.vmi_flag,0)
99: from msc_item_suppliers mis,
100: msc_system_items msi
101: where msi.plan_id = mis.plan_id
102: and msi.sr_instance_id = mis.sr_instance_id
103: and msi.organization_id = mis.organization_id
104: and msi.inventory_item_id = mis.inventory_item_id

Line 407: from msc_system_items msi_1,

403: msi_1.repetitive_type,
404: msi_1.planning_make_buy_code,
405: msi_1.build_in_wip_flag,
406: nvl(f_1.number10,0) vmi_flag
407: from msc_system_items msi_1,
408: msc_hub_query f_1
409: where f_1.query_id(+) = l_qid_vmi
410: and f_1.number1(+) = msi_1.plan_id
411: and f_1.number3(+) = msi_1.sr_instance_id

Line 541: from msc_system_items msi_2,

537: msi_2.base_item_id,
538: msi_2.planning_make_buy_code,
539: msi_2.build_in_wip_flag,
540: nvl(f_3.number10,0) vmi_flag
541: from msc_system_items msi_2,
542: msc_hub_query f_3
543: where f_3.query_id(+) = l_qid_vmi
544: and f_3.number1(+) = msi_2.plan_id
545: and f_3.number3(+) = msi_2.sr_instance_id

Line 741: from msc_system_items msi_1,

737: msi_1.repetitive_type,
738: msi_1.planning_make_buy_code,
739: msi_1.build_in_wip_flag,
740: nvl(f_1.number10,0) vmi_flag
741: from msc_system_items msi_1,
742: msc_hub_query f_1
743: where f_1.query_id(+) = l_qid_vmi
744: and f_1.number1(+) = msi_1.plan_id
745: and f_1.number3(+) = msi_1.sr_instance_id