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_GET_BIS_VALUES dependencies on MSC_BOM_COMPONENTS

Line 68: from msc_bom_components mbc

64: AND mbis.sr_instance_id = l_instance_id
65: AND mbis.plan_id = l_plan_id
66: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
67: and exists ( select 1
68: from msc_bom_components mbc
69: where mbc.organization_id = mbis.organization_id
70: AND mbc.sr_instance_id = mbis.sr_instance_id
71: AND mbc.plan_id = mbis.plan_id
72: and mbc.inventory_item_id = mbis.inventory_item_id

Line 86: from msc_bom_components mbc

82: FROM msc_bis_inv_detail mbis
83: where mbis.plan_id = l_plan_id
84: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
85: and exists ( select 1
86: from msc_bom_components mbc
87: where mbc.organization_id = mbis.organization_id
88: AND mbc.sr_instance_id = mbis.sr_instance_id
89: AND mbc.plan_id = mbis.plan_id
90: and mbc.inventory_item_id = mbis.inventory_item_id

Line 111: from msc_bom_components mbc

107: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
108: and mbis.detail_date between v_start_date and v_end_date
109: AND mbis.plan_id = l_plan_id
110: and exists ( select 1
111: from msc_bom_components mbc
112: where mbc.organization_id = mbis.organization_id
113: AND mbc.sr_instance_id = mbis.sr_instance_id
114: AND mbc.plan_id = mbis.plan_id
115: and mbc.inventory_item_id = mbis.inventory_item_id

Line 132: from msc_bom_components mbc

128: where mbis.detail_date between v_start_date and v_end_date
129: AND mbis.plan_id = l_plan_id
130: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
131: and exists ( select 1
132: from msc_bom_components mbc
133: where mbc.organization_id = mbis.organization_id
134: AND mbc.sr_instance_id = mbis.sr_instance_id
135: AND mbc.plan_id = mbis.plan_id
136: and mbc.inventory_item_id = mbis.inventory_item_id

Line 2135: ' from msc_bom_components mbc ' ||

2131: if p_product_family_id is not null then
2132: where_stat := where_stat ||
2133: ' AND EXISTS '||
2134: ' (select 1 '||
2135: ' from msc_bom_components mbc ' ||
2136: ' where mbc.organization_id = mbis.organization_id '||
2137: ' and mbc.sr_instance_id = mbis.sr_instance_id '||
2138: ' and mbc.plan_id = mbis.plan_id ' ||
2139: ' and mbc.inventory_item_id = mbis.inventory_item_id '||