APPS.EAM_COPY_BOM_PKG dependencies on BOM_COMPONENTS_B

Line 176: FROM bom_components_b bc,

172: AND wdj.organization_id = p_organization_id;
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))

Line 189: FROM bom_components_b bc,

185: AND rownum<2;
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)