APPS.EAM_MAT_REQ_UTILITY_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 130: FROM wip_requirement_operations wro

126: , l_eam_mat_req_rec.suggested_vendor_name
127: , l_eam_mat_req_rec.vendor_id
128: , l_eam_mat_req_rec.unit_price
129: , l_eam_mat_req_rec.released_quantity
130: FROM wip_requirement_operations wro
131: WHERE wro.wip_entity_id = p_wip_entity_id
132: AND wro.organization_id = p_organization_id
133: AND wro.operation_seq_num = p_operation_seq_num
134: AND wro.inventory_item_id = p_inventory_item_id;

Line 181: INSERT INTO WIP_REQUIREMENT_OPERATIONS

177: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Material Requirements rec for ' || p_eam_mat_req_rec.inventory_item_id); END IF;
178: --Bug3946253:Remove round() for the date_required
179:
180:
181: INSERT INTO WIP_REQUIREMENT_OPERATIONS
182: ( wip_entity_id
183: , operation_seq_num
184: , organization_id
185: , inventory_item_id

Line 392: FROM WIP_REQUIREMENT_OPERATIONS

388:
389:
390: SELECT required_quantity
391: INTO l_req_qty
392: FROM WIP_REQUIREMENT_OPERATIONS
393: WHERE wip_entity_id = p_eam_mat_req_rec.wip_entity_id
394: AND ( operation_seq_num = p_eam_mat_req_rec.operation_seq_num
395: OR operation_seq_num = 1 )
396: AND inventory_item_id = p_eam_mat_req_rec.inventory_item_id;

Line 398: UPDATE WIP_REQUIREMENT_OPERATIONS

394: AND ( operation_seq_num = p_eam_mat_req_rec.operation_seq_num
395: OR operation_seq_num = 1 )
396: AND inventory_item_id = p_eam_mat_req_rec.inventory_item_id;
397: --Bug3946253:Remove round() for the date_required
398: UPDATE WIP_REQUIREMENT_OPERATIONS
399: SET quantity_per_assembly = p_eam_mat_req_rec.quantity_per_assembly
400: , operation_seq_num = p_eam_mat_req_rec.operation_seq_num /* Added the column so that op seq num can be changed if it is 1 */
401: , department_id = p_eam_mat_req_rec.department_id
402: , wip_supply_type = p_eam_mat_req_rec.wip_supply_type

Line 503: DELETE FROM WIP_REQUIREMENT_OPERATIONS

499: BEGIN
500:
501: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Material Requirements '|| p_eam_mat_req_rec.inventory_item_id); END IF;
502:
503: DELETE FROM WIP_REQUIREMENT_OPERATIONS
504: WHERE organization_id = p_eam_mat_req_rec.organization_id
505: AND wip_entity_id = p_eam_mat_req_rec.wip_entity_id
506: AND operation_seq_num = p_eam_mat_req_rec.operation_seq_num
507: AND inventory_item_id = p_eam_mat_req_rec.inventory_item_id;

Line 596: FROM wip_requirement_operations

592: SELECT count(*) into l_count
593: FROM dual
594: WHERE exists (
595: SELECT 1
596: FROM wip_requirement_operations
597: WHERE operation_seq_num = p_operation_seq_num
598: and wip_entity_id = p_wip_entity_id
599: and organization_id = p_organization_id
600: ) ;