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 202: FROM mtl_system_items

198: IS
199: l_pick_components NUMBER;
200: CURSOR GetPickComps IS
201: SELECT decode(pick_components_flag, 'Y', 1, 2) pick_comps
202: FROM mtl_system_items
203: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
204: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
205: BEGIN
206:

Line 339: FROM mtl_system_items

335: RETURN NUMBER
336: IS
337: CURSOR c_DefaultRollup is
338: SELECT default_include_in_rollup_flag
339: FROM mtl_system_items
340: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
341: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
342: BEGIN
343:

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

340: WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
341: AND organization_id = g_Rev_Comp_Unexp_Rec.organization_id;
342: BEGIN
343:
344: -- The default for this value comes from the Mtl_System_Items
345: -- Table field Default_Include_In_Rollup_Flag
346: FOR l_DefaultRollup in c_DefaultRollup LOOP
347: IF l_DefaultRollup.Default_include_in_rollup_flag
348: IS NULL OR

Line 372: FROM mtl_system_items assy,

368: RETURN NUMBER
369: IS
370: CURSOR c_CheckATP IS
371: SELECT 1 atp_allowed
372: FROM mtl_system_items assy,
373: mtl_system_items comp
374: WHERE assy.organization_id=g_Rev_Comp_Unexp_Rec.organization_id
375: AND assy.inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id
376: --AND assy.atp_components_flag = 'Y'

Line 373: mtl_system_items comp

369: IS
370: CURSOR c_CheckATP IS
371: SELECT 1 atp_allowed
372: FROM mtl_system_items assy,
373: mtl_system_items comp
374: WHERE assy.organization_id=g_Rev_Comp_Unexp_Rec.organization_id
375: AND assy.inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id
376: --AND assy.atp_components_flag = 'Y'
377: AND comp.organization_id = g_Rev_Comp_Unexp_Rec.organization_id

Line 429: FROM mtl_system_items msi

425: l_bom_item_type NUMBER;
426: BEGIN
427: SELECT bom_item_type
428: INTO l_bom_item_type
429: FROM mtl_system_items msi
430: WHERE msi.inventory_item_id =
431: g_Rev_Comp_Unexp_rec.component_item_id
432: AND msi.organization_id = g_Rev_Comp_Unexp_rec.organization_id;
433:

Line 445: FROM mtl_system_items msi

441: l_unit_price NUMBER;
442: BEGIN
443: SELECT list_price_per_unit
444: INTO l_unit_price
445: FROM mtl_system_items msi
446: WHERE msi.inventory_item_id =
447: g_Rev_Comp_Unexp_rec.component_item_id
448: AND msi.organization_id = g_Rev_Comp_Unexp_rec.organization_id
449: AND msi.inventory_item_flag = 'Y' --- to check whether this is a direct item

Line 648: FROM mtl_system_items

644: CURSOR default_wip_values IS
645: SELECT wip_supply_type,
646: wip_supply_subinventory,
647: wip_supply_locator_id
648: FROM mtl_system_items
649: WHERE inventory_item_id = p_rev_comp_unexp_rec.component_item_id
650: AND organization_id = p_rev_comp_unexp_rec.organization_id;
651: BEGIN
652:

Line 812: FROM Mtl_system_items_b

808:
809: --* Added for Bug 4568522
810: SELECT Bom_Item_Type
811: INTO l_assy_item_type
812: FROM Mtl_system_items_b
813: WHERE organization_id = g_Rev_Comp_Unexp_Rec.organization_id
814: AND inventory_item_id= g_Rev_Comp_Unexp_Rec.Revised_item_id;
815: --* End of Bug 4568522
816: