APPS.EAM_COPY_BOM_PKG dependencies on WIP_DISCRETE_JOBS

Line 168: wip_discrete_jobs wdj

164:
165: -- strt Bug 14539580
166: SELECT msi.effectivity_control into l_effectivity_control
167: FROM mtl_system_items msi,
168: wip_discrete_jobs wdj
169: WHERE msi.inventory_item_id = nvl(wdj.asset_group_id,wdj.rebuild_item_id)
170: AND msi.organization_id = wdj.organization_id
171: AND wdj.wip_entity_id=p_wip_entity_id
172: AND wdj.organization_id = p_organization_id;

Line 178: wip_discrete_jobs wdj

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
182: AND bs.assembly_item_id= nvl(wdj.asset_group_id,wdj.rebuild_item_id)

Line 191: wip_discrete_jobs wdj

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)
195: AND bc.bill_sequence_id = bs.bill_sequence_id