DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OPERATIONS

Line 1974: from wip_operations wo

1970: CURSOR l_op_records_cur is
1971: select
1972: wo.first_unit_start_date as first_unit_start_date,
1973: wo.last_unit_completion_date as last_unit_completion_date
1974: from wip_operations wo
1975: where wo.wip_entity_id = p_wip_entity_id
1976: and wo.organization_id = p_organization_id;
1977:
1978: TYPE l_resource_inst_records IS RECORD (

Line 2033: wip_operations

2029: /* -- find the list of wo operations
2030: IF NOT l_wo_operations%ISOPEN THEN
2031: OPEN l_wo_operations FOR
2032: select * from
2033: wip_operations
2034: where wip_entity_id = l_wip_entity_id and
2035: organization_id = l_organization_id;
2036: END IF;
2037: */

Line 2124: TYPE l_operation_records IS REF CURSOR RETURN WIP_OPERATIONS%ROWTYPE;

2120: x_msg_count OUT NOCOPY NUMBER,
2121: x_msg_data OUT NOCOPY VARCHAR2
2122: ) IS
2123:
2124: TYPE l_operation_records IS REF CURSOR RETURN WIP_OPERATIONS%ROWTYPE;
2125: l_wo_operations l_operation_records;
2126: l_operation_record WIP_OPERATIONS%ROWTYPE;
2127:
2128: TYPE l_resource_records IS RECORD (wip_entity_id NUMBER,

Line 2126: l_operation_record WIP_OPERATIONS%ROWTYPE;

2122: ) IS
2123:
2124: TYPE l_operation_records IS REF CURSOR RETURN WIP_OPERATIONS%ROWTYPE;
2125: l_wo_operations l_operation_records;
2126: l_operation_record WIP_OPERATIONS%ROWTYPE;
2127:
2128: TYPE l_resource_records IS RECORD (wip_entity_id NUMBER,
2129: operation_seq_num NUMBER,
2130: resource_seq_num NUMBER,

Line 2144: from wip_operations wo,

2140: wo.first_unit_start_date as op_start_date,
2141: wo.last_unit_completion_date as op_completion_date,
2142: wor.start_date as res_start_date,
2143: wor.completion_date as res_completion_date
2144: from wip_operations wo,
2145: wip_operation_resources wor
2146: where wo.wip_entity_id = p_wip_entity_id
2147: and wor.wip_entity_id = p_wip_entity_id
2148: and wo.operation_seq_num = wor.operation_seq_num;

Line 2231: wip_operations

2227: -- find the list of wo operations
2228: IF NOT l_wo_operations%ISOPEN THEN
2229: OPEN l_wo_operations FOR
2230: select * from
2231: wip_operations
2232: where wip_entity_id = l_wip_entity_id;
2233: END IF;
2234:
2235:

Line 3960: from wip_operations

3956: WHERE wip_entity_id=l_parent_object_id;
3957:
3958: select min(first_unit_start_date),max(last_unit_completion_date)
3959: INTO l_op_start_date,l_op_end_date
3960: from wip_operations
3961: where wip_entity_id=l_parent_object_id;
3962:
3963: IF(l_op_start_date IS NULL AND l_min_date IS NULL) THEN --no op or children
3964: l_wo_start_date:= NVL(l_requested_start_date,l_requested_due_date); --pick up requested_start_date or due_date