APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1590: from wip_requirement_operations

1586: begin
1587:
1588: select 1, nvl(required_quantity,0)
1589: into l_status, l_required_quantity
1590: from wip_requirement_operations
1591: where wip_entity_id = l_wip_entity_id
1592: and organization_id = l_organization_id
1593: and operation_seq_num = l_operation_seq_num
1594: and inventory_item_id = l_item_id;

Line 1598: update wip_requirement_operations

1594: and inventory_item_id = l_item_id;
1595:
1596: if (l_quantity_received > l_required_quantity ) then
1597:
1598: update wip_requirement_operations
1599: set required_quantity = nvl(l_quantity_received,0)
1600: where wip_entity_id = l_wip_entity_id
1601: and organization_id = l_organization_id
1602: and operation_seq_num = l_operation_seq_num

Line 1609: update wip_requirement_operations

1605: end if;
1606:
1607: if (l_order_type_lookup_code = 'AMOUNT') THEN
1608:
1609: update wip_requirement_operations
1610: set required_quantity = nvl(l_quantity_received,0)
1611: where wip_entity_id = l_wip_entity_id
1612: and organization_id = l_organization_id
1613: and operation_seq_num = l_operation_seq_num

Line 1622: insert into WIP_REQUIREMENT_OPERATIONS

1618: exception
1619:
1620: WHEN NO_DATA_FOUND then
1621:
1622: insert into WIP_REQUIREMENT_OPERATIONS
1623: (INVENTORY_ITEM_ID,
1624: ORGANIZATION_ID,
1625: WIP_ENTITY_ID,
1626: OPERATION_SEQ_NUM,