eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 1640: FROM wip_operation_resource_usage

1636: resource_seq_num,
1637: organization_id,
1638: instance_id,
1639: SUM(completion_date - start_date) usage
1640: FROM wip_operation_resource_usage
1641: GROUP BY wip_entity_id,
1642: operation_seq_num,
1643: resource_seq_num,
1644: organization_id,

Line 1696: FROM wip_operation_resource_usage

1692: resource_seq_num,
1693: organization_id,
1694: instance_id,
1695: SUM(completion_date - start_date) usage
1696: FROM wip_operation_resource_usage
1697: GROUP BY wip_entity_id,
1698: operation_seq_num,
1699: resource_seq_num,
1700: organization_id,

Line 1753: FROM wip_operation_resource_usage

1749: resource_seq_num,
1750: organization_id,
1751: instance_id,
1752: SUM(completion_date - start_date) usage
1753: FROM wip_operation_resource_usage
1754: GROUP BY wip_entity_id,
1755: operation_seq_num,
1756: resource_seq_num,
1757: organization_id,

Line 1810: FROM wip_operation_resource_usage woru

1806: resource_seq_num,
1807: organization_id,
1808: instance_id,
1809: SUM(completion_date - start_date) usage
1810: FROM wip_operation_resource_usage woru
1811: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1812: (SELECT 1
1813: FROM wip_op_resource_instances wori
1814: WHERE woru.wip_entity_id = wori.wip_entity_id

Line 1887: FROM wip_operation_resource_usage woru

1883: resource_seq_num,
1884: organization_id,
1885: instance_id,
1886: SUM(completion_date - start_date) usage
1887: FROM wip_operation_resource_usage woru
1888: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1889: (SELECT 1
1890: FROM wip_op_resource_instances wori
1891: WHERE woru.wip_entity_id = wori.wip_entity_id

Line 1963: FROM wip_operation_resource_usage woru

1959: resource_seq_num,
1960: organization_id,
1961: instance_id,
1962: SUM(completion_date - start_date) usage
1963: FROM wip_operation_resource_usage woru
1964: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1965: (SELECT 1
1966: FROM wip_op_resource_instances wori
1967: WHERE woru.wip_entity_id = wori.wip_entity_id

Line 3348: update wip_operation_resource_usage

3344: l_stmt_num := 20;
3345: if (nvl(p_update_hierarchy, 'N') = 'N') then
3346:
3347: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3348: update wip_operation_resource_usage
3349: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3350: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3351: where wip_entity_id = p_wip_entity_id
3352: and organization_id = p_organization_id;

Line 3355: update wip_operation_resource_usage

3351: where wip_entity_id = p_wip_entity_id
3352: and organization_id = p_organization_id;
3353:
3354: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3355: update wip_operation_resource_usage
3356: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3357: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3358: where wip_entity_id = p_wip_entity_id
3359: and organization_id = p_organization_id

Line 3363: update wip_operation_resource_usage

3359: and organization_id = p_organization_id
3360: and operation_seq_num = p_operation_seq_num;
3361:
3362: else
3363: update wip_operation_resource_usage
3364: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3365: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3366: where wip_entity_id = p_wip_entity_id
3367: and organization_id = p_organization_id

Line 3376: update wip_operation_resource_usage

3372: null;
3373:
3374: else
3375: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3376: update wip_operation_resource_usage
3377: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3378: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3379: where wip_entity_id in (select p_wip_entity_id from dual
3380: union

Line 3388: update wip_operation_resource_usage

3384: connect by prior child_object_id = parent_object_id )
3385: and organization_id = p_organization_id;
3386:
3387: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3388: update wip_operation_resource_usage
3389: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3390: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3391: where wip_entity_id in (select p_wip_entity_id from dual
3392: union

Line 3400: update wip_operation_resource_usage

3396: connect by prior child_object_id = parent_object_id )
3397: and organization_id = p_organization_id;
3398:
3399: else
3400: update wip_operation_resource_usage
3401: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3402: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3403: where wip_entity_id in (select p_wip_entity_id from dual
3404: union

Line 3481: from wip_operation_resource_usage woru

3477: p_organization_id number,
3478: p_operation_seq_num number,
3479: p_resource_seq_num number) is
3480: select woru.start_date, woru.completion_date, woru.instance_id
3481: from wip_operation_resource_usage woru
3482: where woru.wip_entity_id = p_wip_entity_id
3483: and woru.operation_seq_num = p_operation_seq_num
3484: and woru.resource_seq_num = p_resource_seq_num
3485: and woru.organization_id = p_organization_id;

Line 3537: from wip_operation_resource_usage woru

3533: BEGIN
3534:
3535: select min(WORU.start_date), max(WORU.completion_date)
3536: into l_min_woru_start_date, l_max_woru_end_date
3537: from wip_operation_resource_usage woru
3538: where woru.wip_entity_id = p_wip_entity_id
3539: and woru.operation_seq_num = p_operation_seq_num
3540: and woru.resource_seq_num = p_resource_seq_num
3541: and woru.organization_id = p_organization_id;

Line 3574: update wip_operation_resource_usage woru

3570: if (l_wor_start_date <= l_min_woru_start_date ) then
3571: --WORU is still encompassed by WOR.
3572: --It is an expand of WOR dates
3573: --Update the rows in WORU where instance_id is null
3574: update wip_operation_resource_usage woru
3575: set start_date = l_wor_start_date
3576: where woru.wip_entity_id = p_wip_entity_id
3577: and woru.operation_seq_num = p_operation_seq_num
3578: and woru.resource_seq_num = p_resource_seq_num

Line 3593: update wip_operation_resource_usage woru

3589: if ( l_wor_end_date >= l_max_woru_end_date) then
3590: --WORU is still encompassed by WOR.
3591: --It is an expand of WOR dates
3592: --Update the rows in WORU where instance_id is null
3593: update wip_operation_resource_usage woru
3594: set completion_date = l_wor_end_date
3595: where woru.wip_entity_id = p_wip_entity_id
3596: and woru.operation_seq_num = p_operation_seq_num
3597: and woru.resource_seq_num = p_resource_seq_num

Line 3619: from wip_operation_resource_usage woru

3615: changing duration, query woru again to get the recently updated data*/
3616:
3617: select min(WORU.start_date), max(WORU.completion_date)
3618: into l_min_woru_start_date, l_max_woru_end_date
3619: from wip_operation_resource_usage woru
3620: where woru.wip_entity_id = p_wip_entity_id
3621: and woru.operation_seq_num = p_operation_seq_num
3622: and woru.resource_seq_num = p_resource_seq_num
3623: and woru.organization_id = p_organization_id;

Line 3632: from wip_operation_resource_usage woru

3628: l_wor_duration := l_wor_end_date - l_wor_start_date;
3629:
3630: select count(*)
3631: into l_instance_count
3632: from wip_operation_resource_usage woru
3633: where woru.wip_entity_id = p_wip_entity_id
3634: and woru.operation_seq_num = p_operation_seq_num
3635: and woru.resource_seq_num = p_resource_seq_num
3636: and woru.organization_id = p_organization_id