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.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_OPERATION_RESOURCES

Line 63: DELETE FROM WIP_OPERATION_RESOURCES

59: p_resource_seq_num => cur_row.resource_seq_num,
60: p_organization_id => p_organization_id
61: );
62:
63: DELETE FROM WIP_OPERATION_RESOURCES
64: WHERE wip_entity_id = p_wip_entity_id
65: AND organization_id = p_organization_id
66: AND operation_seq_num = cur_row.operation_seq_num
67: AND resource_seq_num = cur_row.resource_seq_num

Line 134: DELETE FROM WIP_OPERATION_RESOURCES

130: p_wip_entity_id,
131: p_organization_id) LOOP
132: -- if adding setup resource, delete all existing setup resources
133: if (cur_row.parent_seq_num is not null) then
134: DELETE FROM WIP_OPERATION_RESOURCES
135: WHERE wip_entity_id = p_wip_entity_id
136: AND organization_id = p_organization_id
137: AND operation_seq_num = cur_row.operation_seq_num
138: AND parent_resource_seq = cur_row.parent_seq_num;

Line 148: INSERT INTO WIP_OPERATION_RESOURCES(

144: p_organization_id) LOOP
145:
146:
147: /* insert into table */
148: INSERT INTO WIP_OPERATION_RESOURCES(
149: wip_entity_id,
150: organization_id,
151: operation_seq_num,
152: resource_seq_num,

Line 388: from wip_operation_resources wor,

384: cursor missing_res_csr
385: is
386: select wo.first_unit_start_date,
387: rowidtochar(wor.rowid)
388: from wip_operation_resources wor,
389: wip_operations wo
390: where wo.wip_entity_id = wor.wip_entity_id
391: and wo.organization_id = wor.organization_id
392: and wo.operation_seq_num = wor.operation_seq_num

Line 439: from wip_operation_resources

435: l_replace_res := 0;
436:
437: select substitute_group_num
438: into l_current_sub
439: from wip_operation_resources
440: where wip_entity_id = p_wip_entity_id
441: and operation_seq_num = cur_row.operation_seq_num
442: and resource_seq_num = cur_row.resource_seq_num;
443:

Line 471: UPDATE WIP_OPERATION_RESOURCES

467: cur_row.replacement_group_num,
468: x_status,
469: x_msg_count,
470: x_msg_data);
471: UPDATE WIP_OPERATION_RESOURCES
472: SET start_date = NVL(cur_row.start_date,start_date),
473: completion_date = NVL(cur_row.completion_date,completion_date),
474: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
475: WHERE wip_entity_id = p_wip_entity_id

Line 495: UPDATE WIP_OPERATION_RESOURCES

491: P_ORGANIZATION_ID => P_ORGANIZATION_ID
492: );
493: END IF;
494:
495: UPDATE WIP_OPERATION_RESOURCES
496: SET resource_id = cur_row.resource_id_new,
497: usage_rate_or_amount = nvl(cur_row.usage_rate_or_amount,
498: usage_rate_or_amount),
499: last_update_date = sysdate,/*BUG 6721823*/

Line 674: update wip_operation_resources

670: bulk collect into l_fusdTbl, l_rowidTbl ;
671: close missing_res_csr ;
672:
673: forall i in 1..l_fusdTbl.count
674: update wip_operation_resources
675: set start_date = l_fusdTbl(i),
676: completion_date = l_fusdTbl(i),
677: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
678: where rowid = chartorowid(l_rowidTbl(i)) ;

Line 1874: from wip_operation_resources wor

1870: So compare the WOR dates with the WO dates and update the WOR dates so that the validation does not fail */
1871: DECLARE
1872: CURSOR C_WOR IS
1873: select start_date, completion_date, rowid
1874: from wip_operation_resources wor
1875: where wor.wip_entity_id = p_wip_entity_id
1876: and wor.organization_id = p_organization_id
1877: and wor.operation_seq_num = cur_oper.operation_seq_num;
1878:

Line 1895: UPDATE WIP_OPERATION_RESOURCES

1891: l_wor_completion_date := l_last_unit_completion_date;
1892: END IF;
1893:
1894: IF ((l_wor_start_date IS NOT NULL) OR (l_wor_completion_date IS NOT NULL)) THEN
1895: UPDATE WIP_OPERATION_RESOURCES
1896: SET start_date = nvl(l_wor_start_date, start_date),
1897: completion_date = nvl(l_wor_completion_date, completion_date),
1898: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
1899: WHERE rowid = rec.rowid;

Line 2321: from wip_operation_resources wor

2317: and wo.organization_id = p_organization_id
2318: and wo.operation_seq_num = wjdi.operation_seq_num
2319: and (wo.first_unit_start_date >
2320: (select min(start_date)
2321: from wip_operation_resources wor
2322: where wor.wip_entity_id = p_wip_entity_id
2323: and wor.organization_id = p_organization_id
2324: and wor.operation_seq_num = wo.operation_seq_num)
2325: or

Line 2328: from wip_operation_resources wor

2324: and wor.operation_seq_num = wo.operation_seq_num)
2325: or
2326: wo.last_unit_completion_date <
2327: (select max(completion_date)
2328: from wip_operation_resources wor
2329: where wor.wip_entity_id = p_wip_entity_id
2330: and wor.organization_id = p_organization_id
2331: and wor.operation_seq_num = wo.operation_seq_num)));
2332:

Line 2372: from wip_operation_resources wor

2368: and wo.organization_id = p_organization_id
2369: and wo.operation_seq_num = wjdi.operation_seq_num
2370: and (wo.first_unit_start_date >
2371: (select min(start_date)
2372: from wip_operation_resources wor
2373: where wor.wip_entity_id = p_wip_entity_id
2374: and wor.organization_id = p_organization_id
2375: and wor.operation_seq_num = wo.operation_seq_num)
2376: or

Line 2379: from wip_operation_resources wor

2375: and wor.operation_seq_num = wo.operation_seq_num)
2376: or
2377: wo.last_unit_completion_date <
2378: (select max(completion_date)
2379: from wip_operation_resources wor
2380: where wor.wip_entity_id = p_wip_entity_id
2381: and wor.organization_id = p_organization_id
2382: and wor.operation_seq_num = wo.operation_seq_num)));
2383:

Line 2646: FROM WIP_OPERATION_RESOURCES

2642: PROGRAM_UPDATE_DATE,
2643: START_DATE,
2644: COMPLETION_DATE,
2645: ASSIGNED_UNITS
2646: FROM WIP_OPERATION_RESOURCES
2647: WHERE wip_entity_id = p_wip_entity_id
2648: AND organization_id = p_organization_id
2649: AND operation_seq_num = p_operation_seq_num
2650: AND resource_seq_num = p_resource_seq_num;