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

Line 130: FROM mtl_system_items

126: IS
127: l_pick_components NUMBER;
128: CURSOR GetPickComps IS
129: SELECT decode(pick_components_flag, 'Y', 1, 2) pick_comps
130: FROM mtl_system_items
131: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
132: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
133: BEGIN
134:

Line 267: FROM mtl_system_items

263: RETURN NUMBER
264: IS
265: CURSOR c_DefaultRollup is
266: SELECT default_include_in_rollup_flag
267: FROM mtl_system_items
268: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
269: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
270: BEGIN
271:

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

268: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
269: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
270: BEGIN
271:
272: -- The default for this value comes from the Mtl_System_Items
273: -- Table field Default_Include_In_Rollup_Flag
274: FOR l_DefaultRollup in c_DefaultRollup LOOP
275: IF l_DefaultRollup.Default_include_in_rollup_flag
276: IS NULL OR

Line 300: FROM mtl_system_items assy,

296: RETURN NUMBER
297: IS
298: CURSOR c_CheckATP IS
299: SELECT 1 atp_allowed
300: FROM mtl_system_items assy,
301: mtl_system_items comp
302: WHERE assy.organization_id=g_Rev_Comp_Unexp_Rec.organization_id
303: AND assy.inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id
304: --AND assy.atp_components_flag = 'Y'

Line 301: mtl_system_items comp

297: IS
298: CURSOR c_CheckATP IS
299: SELECT 1 atp_allowed
300: FROM mtl_system_items assy,
301: mtl_system_items comp
302: WHERE assy.organization_id=g_Rev_Comp_Unexp_Rec.organization_id
303: AND assy.inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id
304: --AND assy.atp_components_flag = 'Y'
305: AND comp.organization_id = g_Rev_Comp_Unexp_Rec.organization_id

Line 357: FROM mtl_system_items msi

353: l_bom_item_type NUMBER;
354: BEGIN
355: SELECT bom_item_type
356: INTO l_bom_item_type
357: FROM mtl_system_items msi
358: WHERE msi.inventory_item_id =
359: g_Rev_Comp_Unexp_rec.component_item_id
360: AND msi.organization_id = g_Rev_Comp_Unexp_rec.organization_id;
361:

Line 373: FROM mtl_system_items msi

369: l_unit_price NUMBER;
370: BEGIN
371: SELECT list_price_per_unit
372: INTO l_unit_price
373: FROM mtl_system_items msi
374: WHERE msi.inventory_item_id =
375: g_Rev_Comp_Unexp_rec.component_item_id
376: AND msi.organization_id = g_Rev_Comp_Unexp_rec.organization_id
377: AND msi.inventory_item_flag = 'Y' --- to check whether this is a direct item

Line 573: FROM mtl_system_items

569: CURSOR default_wip_values IS
570: SELECT wip_supply_type,
571: wip_supply_subinventory,
572: wip_supply_locator_id
573: FROM mtl_system_items
574: WHERE inventory_item_id = p_rev_comp_unexp_rec.component_item_id
575: AND organization_id = p_rev_comp_unexp_rec.organization_id;
576: BEGIN
577:

Line 677: FROM Mtl_system_items_b

673:
674: --* Added for Bug 4568522
675: SELECT Bom_Item_Type
676: INTO l_assy_item_type
677: FROM Mtl_system_items_b
678: WHERE organization_id = g_Rev_Comp_Unexp_Rec.organization_id
679: AND inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id;
680: --* End of Bug 4568522
681: