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.ENG_DEFAULT_REV_COMPONENT dependencies on MTL_SYSTEM_ITEMS

Line 97: FROM mtl_system_items

93: IS
94: l_pick_components NUMBER;
95: CURSOR GetPickComps IS
96: SELECT decode(pick_components_flag, 'Y', 1, 2) pick_comps
97: FROM mtl_system_items
98: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
99: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
100: BEGIN
101:

Line 200: FROM mtl_system_items

196: RETURN NUMBER
197: IS
198: CURSOR c_DefaultRollup is
199: SELECT default_include_in_rollup_flag
200: FROM mtl_system_items
201: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
202: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
203: BEGIN
204:

Line 205: -- The default for this value comes from the Mtl_System_Items

201: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
202: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
203: BEGIN
204:
205: -- The default for this value comes from the Mtl_System_Items
206: -- Table field Default_Include_In_Rollup_Flag
207: FOR l_DefaultRollup in c_DefaultRollup LOOP
208: IF l_DefaultRollup.Default_include_in_rollup_flag IS NULL OR
209: l_DefaultRollup.Default_include_in_rollup_flag = 'Y'

Line 232: FROM mtl_system_items assy,

228: RETURN NUMBER
229: IS
230: CURSOR c_CheckATP IS
231: SELECT 1 atp_allowed
232: FROM mtl_system_items assy,
233: mtl_system_items comp
234: WHERE assy.organization_id = g_Rev_Comp_Unexp_Rec.organization_id
235: AND assy.inventory_item_id = g_Rev_Comp_Unexp_Rec.Revised_item_id
236: AND assy.atp_components_flag = 'Y'

Line 233: mtl_system_items comp

229: IS
230: CURSOR c_CheckATP IS
231: SELECT 1 atp_allowed
232: FROM mtl_system_items assy,
233: mtl_system_items comp
234: WHERE assy.organization_id = g_Rev_Comp_Unexp_Rec.organization_id
235: AND assy.inventory_item_id = g_Rev_Comp_Unexp_Rec.Revised_item_id
236: AND assy.atp_components_flag = 'Y'
237: AND comp.organization_id = g_Rev_Comp_Unexp_Rec.organization_id

Line 287: FROM mtl_system_items msi

283: l_bom_item_type NUMBER;
284: BEGIN
285: SELECT bom_item_type
286: INTO l_bom_item_type
287: FROM mtl_system_items msi
288: WHERE msi.inventory_item_id = g_Rev_Comp_Unexp_rec.component_item_id
289: AND msi.organization_id = g_Rev_Comp_Unexp_rec.organization_id;
290:
291: RETURN l_bom_item_type;