APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1657: from wip_requirement_operations

1653: begin
1654:
1655: select 1, nvl(required_quantity,0)
1656: into l_status, l_required_quantity
1657: from wip_requirement_operations
1658: where wip_entity_id = l_wip_entity_id
1659: and organization_id = l_organization_id
1660: and operation_seq_num = l_operation_seq_num
1661: and inventory_item_id = l_item_id;

Line 1665: update wip_requirement_operations

1661: and inventory_item_id = l_item_id;
1662:
1663: if (l_quantity_received > l_required_quantity ) then
1664:
1665: update wip_requirement_operations
1666: set required_quantity = nvl(l_quantity_received,0)
1667: where wip_entity_id = l_wip_entity_id
1668: and organization_id = l_organization_id
1669: and operation_seq_num = l_operation_seq_num

Line 1676: update wip_requirement_operations

1672: end if;
1673:
1674: if (l_order_type_lookup_code = 'AMOUNT') THEN
1675:
1676: update wip_requirement_operations
1677: set required_quantity = nvl(l_quantity_received,0)
1678: where wip_entity_id = l_wip_entity_id
1679: and organization_id = l_organization_id
1680: and operation_seq_num = l_operation_seq_num

Line 1689: insert into WIP_REQUIREMENT_OPERATIONS

1685: exception
1686:
1687: WHEN NO_DATA_FOUND then
1688:
1689: insert into WIP_REQUIREMENT_OPERATIONS
1690: (INVENTORY_ITEM_ID,
1691: ORGANIZATION_ID,
1692: WIP_ENTITY_ID,
1693: OPERATION_SEQ_NUM,