[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT first_unit_start_date
INTO l_material_req_table(i).date_required
FROM wip_operations
WHERE wip_entity_id = p_wip_entity_id
AND operation_seq_num = p_operation_seq_num
AND organization_id = p_organization_id;
SELECT msi.effectivity_control into l_effectivity_control
FROM mtl_system_items msi,
wip_discrete_jobs wdj
WHERE msi.inventory_item_id = nvl(wdj.asset_group_id,wdj.rebuild_item_id)
AND msi.organization_id = wdj.organization_id
AND wdj.wip_entity_id=p_wip_entity_id
AND wdj.organization_id = p_organization_id;
SELECT auto_request_material INTO l_material_req_table(i).AUTO_REQUEST_MATERIAL
FROM bom_components_b bc,
bom_structures_b bs,
wip_discrete_jobs wdj
WHERE bc.component_item_id= p_bom_table(l_index).component_item_id
AND (bc.effectivity_date <= sysdate and (bc.disable_date >= sysdate or bc.disable_date is null))
AND bc.bill_sequence_id = bs.bill_sequence_id
AND bs.assembly_item_id= nvl(wdj.asset_group_id,wdj.rebuild_item_id)
AND bs.organization_id=p_organization_id
AND wdj.wip_entity_id=p_wip_entity_id
AND rownum<2;
SELECT auto_request_material INTO l_material_req_table(i).AUTO_REQUEST_MATERIAL
FROM bom_components_b bc,
bom_structures_b bs,
wip_discrete_jobs wdj
WHERE bc.component_item_id = p_bom_table(l_index).component_item_id
AND bc.from_end_item_unit_number <= nvl(wdj.asset_number,wdj.rebuild_serial_number)
AND (bc.to_end_item_unit_number >=nvl(wdj.asset_number,wdj.rebuild_serial_number) OR bc.to_end_item_unit_number IS NULL)
AND bc.bill_sequence_id = bs.bill_sequence_id
AND bs.assembly_item_id= nvl(wdj.asset_group_id,wdj.rebuild_item_id)
AND bs.organization_id=p_organization_id
AND wdj.wip_entity_id=p_wip_entity_id
AND rownum<2;
SELECT LIST_PRICE_PER_UNIT
INTO l_material_req_table(i).unit_price
FROM mtl_system_items_vl
WHERE inventory_item_id=p_bom_table(l_index).component_item_id
AND stock_enabled_flag='N'
AND organization_id = p_organization_id;