APPS.EAM_MTL_TXN_PROCESS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 230: from wip_requirement_operations

226: and process_flag = 1; --1(ready). Do not pick up 3(errored) or 2(not ready)
227:
228: if (l_mti_qty > 0) then
229: select quantity_issued into l_qty_issued
230: from wip_requirement_operations
231: where wip_entity_id = p_trx_src_id
232: and inventory_item_id = p_item_id;
233: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
234: 'Qty to return in MTI='|| l_mti_qty|| ', Qty to return by user='

Line 466: from wip_requirement_operations

462:
463: begin
464: select department_id
465: into l_department_id
466: from wip_requirement_operations
467: where wip_entity_id = p_trx_src_id
468: and operation_seq_num = p_operation_seq_num
469: and organization_id = p_org_id
470: and inventory_item_id=p_item_id;

Line 797: UPDATE wip_requirement_operations

793: end loop;
794: close txn_temp_id_cur;
795:
796: -- Sets Required quantity
797: UPDATE wip_requirement_operations
798: SET required_quantity = quantity_issued
799: WHERE organization_id = p_org_id
800: AND wip_entity_id = p_trx_src_id
801: AND operation_seq_num = p_operation_seq_num

Line 1626: -- entry into WIP_REQUIREMENT_OPERATIONS

1622:
1623:
1624:
1625: if(p_mode='INSERT') then
1626: -- entry into WIP_REQUIREMENT_OPERATIONS
1627:
1628: l_eam_mat_req_rec.batch_id := 1;
1629: l_eam_mat_req_rec.header_id := p_wip_entity_id;
1630: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;