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 1639: FROM wip_operation_resource_usage

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

Line 1695: FROM wip_operation_resource_usage

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

Line 1752: FROM wip_operation_resource_usage

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

Line 1809: FROM wip_operation_resource_usage woru

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

Line 1886: FROM wip_operation_resource_usage woru

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

Line 1962: FROM wip_operation_resource_usage woru

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

Line 3204: update wip_operation_resource_usage

3200: l_stmt_num := 20;
3201: if (nvl(p_update_hierarchy, 'N') = 'N') then
3202:
3203: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3204: update wip_operation_resource_usage
3205: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3206: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3207: where wip_entity_id = p_wip_entity_id
3208: and organization_id = p_organization_id;

Line 3211: update wip_operation_resource_usage

3207: where wip_entity_id = p_wip_entity_id
3208: and organization_id = p_organization_id;
3209:
3210: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3211: update wip_operation_resource_usage
3212: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3213: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3214: where wip_entity_id = p_wip_entity_id
3215: and organization_id = p_organization_id

Line 3219: update wip_operation_resource_usage

3215: and organization_id = p_organization_id
3216: and operation_seq_num = p_operation_seq_num;
3217:
3218: else
3219: update wip_operation_resource_usage
3220: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3221: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3222: where wip_entity_id = p_wip_entity_id
3223: and organization_id = p_organization_id

Line 3232: update wip_operation_resource_usage

3228: null;
3229:
3230: else
3231: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3232: update wip_operation_resource_usage
3233: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3234: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3235: where wip_entity_id in (select p_wip_entity_id from dual
3236: union

Line 3244: update wip_operation_resource_usage

3240: connect by prior child_object_id = parent_object_id )
3241: and organization_id = p_organization_id;
3242:
3243: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3244: update wip_operation_resource_usage
3245: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3246: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3247: where wip_entity_id in (select p_wip_entity_id from dual
3248: union

Line 3256: update wip_operation_resource_usage

3252: connect by prior child_object_id = parent_object_id )
3253: and organization_id = p_organization_id;
3254:
3255: else
3256: update wip_operation_resource_usage
3257: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3258: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3259: where wip_entity_id in (select p_wip_entity_id from dual
3260: union

Line 3337: from wip_operation_resource_usage woru

3333: p_organization_id number,
3334: p_operation_seq_num number,
3335: p_resource_seq_num number) is
3336: select woru.start_date, woru.completion_date, woru.instance_id
3337: from wip_operation_resource_usage woru
3338: where woru.wip_entity_id = p_wip_entity_id
3339: and woru.operation_seq_num = p_operation_seq_num
3340: and woru.resource_seq_num = p_resource_seq_num
3341: and woru.organization_id = p_organization_id;

Line 3393: from wip_operation_resource_usage woru

3389: BEGIN
3390:
3391: select min(WORU.start_date), max(WORU.completion_date)
3392: into l_min_woru_start_date, l_max_woru_end_date
3393: from wip_operation_resource_usage woru
3394: where woru.wip_entity_id = p_wip_entity_id
3395: and woru.operation_seq_num = p_operation_seq_num
3396: and woru.resource_seq_num = p_resource_seq_num
3397: and woru.organization_id = p_organization_id;

Line 3430: update wip_operation_resource_usage woru

3426: if (l_wor_start_date <= l_min_woru_start_date ) then
3427: --WORU is still encompassed by WOR.
3428: --It is an expand of WOR dates
3429: --Update the rows in WORU where instance_id is null
3430: update wip_operation_resource_usage woru
3431: set start_date = l_wor_start_date
3432: where woru.wip_entity_id = p_wip_entity_id
3433: and woru.operation_seq_num = p_operation_seq_num
3434: and woru.resource_seq_num = p_resource_seq_num

Line 3449: update wip_operation_resource_usage woru

3445: if ( l_wor_end_date >= l_max_woru_end_date) then
3446: --WORU is still encompassed by WOR.
3447: --It is an expand of WOR dates
3448: --Update the rows in WORU where instance_id is null
3449: update wip_operation_resource_usage woru
3450: set completion_date = l_wor_end_date
3451: where woru.wip_entity_id = p_wip_entity_id
3452: and woru.operation_seq_num = p_operation_seq_num
3453: and woru.resource_seq_num = p_resource_seq_num

Line 3475: from wip_operation_resource_usage woru

3471: changing duration, query woru again to get the recently updated data*/
3472:
3473: select min(WORU.start_date), max(WORU.completion_date)
3474: into l_min_woru_start_date, l_max_woru_end_date
3475: from wip_operation_resource_usage woru
3476: where woru.wip_entity_id = p_wip_entity_id
3477: and woru.operation_seq_num = p_operation_seq_num
3478: and woru.resource_seq_num = p_resource_seq_num
3479: and woru.organization_id = p_organization_id;

Line 3488: from wip_operation_resource_usage woru

3484: l_wor_duration := l_wor_end_date - l_wor_start_date;
3485:
3486: select count(*)
3487: into l_instance_count
3488: from wip_operation_resource_usage woru
3489: where woru.wip_entity_id = p_wip_entity_id
3490: and woru.operation_seq_num = p_operation_seq_num
3491: and woru.resource_seq_num = p_resource_seq_num
3492: and woru.organization_id = p_organization_id