APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OPERATIONS

Line 1947: from wip_operations wo

1943: CURSOR l_op_records_cur is
1944: select
1945: wo.first_unit_start_date as first_unit_start_date,
1946: wo.last_unit_completion_date as last_unit_completion_date
1947: from wip_operations wo
1948: where wo.wip_entity_id = p_wip_entity_id
1949: and wo.organization_id = p_organization_id;
1950:
1951: TYPE l_resource_inst_records IS RECORD (

Line 2006: wip_operations

2002: /* -- find the list of wo operations
2003: IF NOT l_wo_operations%ISOPEN THEN
2004: OPEN l_wo_operations FOR
2005: select * from
2006: wip_operations
2007: where wip_entity_id = l_wip_entity_id and
2008: organization_id = l_organization_id;
2009: END IF;
2010: */

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

2093: x_msg_count OUT NOCOPY NUMBER,
2094: x_msg_data OUT NOCOPY VARCHAR2
2095: ) IS
2096:
2097: TYPE l_operation_records IS REF CURSOR RETURN WIP_OPERATIONS%ROWTYPE;
2098: l_wo_operations l_operation_records;
2099: l_operation_record WIP_OPERATIONS%ROWTYPE;
2100:
2101: TYPE l_resource_records IS RECORD (wip_entity_id NUMBER,

Line 2099: l_operation_record WIP_OPERATIONS%ROWTYPE;

2095: ) IS
2096:
2097: TYPE l_operation_records IS REF CURSOR RETURN WIP_OPERATIONS%ROWTYPE;
2098: l_wo_operations l_operation_records;
2099: l_operation_record WIP_OPERATIONS%ROWTYPE;
2100:
2101: TYPE l_resource_records IS RECORD (wip_entity_id NUMBER,
2102: operation_seq_num NUMBER,
2103: resource_seq_num NUMBER,

Line 2117: from wip_operations wo,

2113: wo.first_unit_start_date as op_start_date,
2114: wo.last_unit_completion_date as op_completion_date,
2115: wor.start_date as res_start_date,
2116: wor.completion_date as res_completion_date
2117: from wip_operations wo,
2118: wip_operation_resources wor
2119: where wo.wip_entity_id = p_wip_entity_id
2120: and wor.wip_entity_id = p_wip_entity_id
2121: and wo.operation_seq_num = wor.operation_seq_num;

Line 2204: wip_operations

2200: -- find the list of wo operations
2201: IF NOT l_wo_operations%ISOPEN THEN
2202: OPEN l_wo_operations FOR
2203: select * from
2204: wip_operations
2205: where wip_entity_id = l_wip_entity_id;
2206: END IF;
2207:
2208:

Line 3933: from wip_operations

3929: WHERE wip_entity_id=l_parent_object_id;
3930:
3931: select min(first_unit_start_date),max(last_unit_completion_date)
3932: INTO l_op_start_date,l_op_end_date
3933: from wip_operations
3934: where wip_entity_id=l_parent_object_id;
3935:
3936: IF(l_op_start_date IS NULL AND l_min_date IS NULL) THEN --no op or children
3937: l_wo_start_date:= NVL(l_requested_start_date,l_requested_due_date); --pick up requested_start_date or due_date