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.MRP_END_ASSY dependencies on MRP_BOM_COMPONENTS

Line 28: FROM mrp_bom_components bom,

24: cursor get_us_assy(c_org_id number, c_compile_desig varchar2,
25: c_component number) IS
26: SELECT bom.using_assembly_id using_assembly_item_id,
27: sum(bom.usage_quantity) operation_usage_quantity
28: FROM mrp_bom_components bom,
29: mrp_plan_organizations_v plans
30: WHERE bom.compile_designator = c_compile_desig
31: AND bom.compile_designator = plans.compile_designator
32: AND trunc(bom.effectivity_date) <= trunc(plans.CUTOFF_DATE)

Line 83: FROM mrp_bom_components

79: -- then the using assembly is an end assembly.)
80: --
81: SELECT count(inventory_item_id)
82: INTO check_table
83: FROM mrp_bom_components
84: WHERE organization_id = p_org_id
85: AND compile_designator = p_compile_desig
86: AND alternate_bom_designator is null
87: AND inventory_item_id = ea.using_assembly_item_id