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.EAM_COPY_BOM_PKG dependencies on BOM_STRUCTURES_B

Line 177: bom_structures_b bs,

173:
174: if l_effectivity_control=1 then -- Dates effectivity
175: SELECT auto_request_material INTO l_material_req_table(i).AUTO_REQUEST_MATERIAL
176: FROM bom_components_b bc,
177: bom_structures_b bs,
178: wip_discrete_jobs wdj
179: WHERE bc.component_item_id= p_bom_table(l_index).component_item_id
180: AND (bc.effectivity_date <= sysdate and (bc.disable_date >= sysdate or bc.disable_date is null))
181: AND bc.bill_sequence_id = bs.bill_sequence_id

Line 190: bom_structures_b bs,

186:
187: elsif l_effectivity_control=2 then -- Unit/Serial effectivity
188: SELECT auto_request_material INTO l_material_req_table(i).AUTO_REQUEST_MATERIAL
189: FROM bom_components_b bc,
190: bom_structures_b bs,
191: wip_discrete_jobs wdj
192: WHERE bc.component_item_id = p_bom_table(l_index).component_item_id
193: AND bc.from_end_item_unit_number <= nvl(wdj.asset_number,wdj.rebuild_serial_number)
194: AND (bc.to_end_item_unit_number >=nvl(wdj.asset_number,wdj.rebuild_serial_number) OR bc.to_end_item_unit_number IS NULL)