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

Line 143: UPDATE WIP_OPERATION_RESOURCES

139: ORGANIZATION_ID = i_org_id;
140:
141: stmt_num := 20;
142:
143: UPDATE WIP_OPERATION_RESOURCES
144: SET temp_relieved_value = 0
145: WHERE
146: WIP_ENTITY_ID = i_wip_entity_id AND
147: ORGANIZATION_ID = i_org_id;

Line 219: FROM wip_operation_resources wor

215: WHERE wro.wip_entity_id = i_wip_entity_id
216: AND wro.quantity_per_assembly <>0
217: UNION ALL
218: SELECT NULL
219: FROM wip_operation_resources wor
220: WHERE wor.wip_entity_id = i_wip_entity_id
221: AND wor.usage_rate_or_amount <>0
222: );
223:

Line 482: UPDATE wip_operation_resources w

478: * flush out TL Resource costs and units ... *
479: *******************************************************/
480:
481: stmt_num := 120;
482: UPDATE wip_operation_resources w
483: SET
484: (relieved_res_completion_units,
485: relieved_res_completion_value,
486: temp_relieved_value

Line 508: FROM wip_operation_resources w2

504: nvl(applied_resource_value,0)-
505: nvl(relieved_res_completion_value,0)-
506: nvl(relieved_variance_value,0)-
507: nvl(relieved_res_scrap_value,0)
508: FROM wip_operation_resources w2
509: WHERE
510: w.wip_entity_id = w2.wip_entity_id and
511: w.organization_id = w2.organization_id and
512: w.operation_seq_num = w2.operation_seq_num and

Line 519: FROM wip_operation_resources wor,

515: WHERE w.wip_entity_id = i_wip_entity_id
516: AND w.organization_id = i_org_id
517: AND EXISTS
518: (SELECT null
519: FROM wip_operation_resources wor,
520: bom_resources br
521: WHERE wor.wip_entity_id = i_wip_entity_id
522: AND wor.organization_id = i_org_id
523: AND wor.organization_id = br.organization_id

Line 527: FROM wip_operation_resources w3,

523: AND wor.organization_id = br.organization_id
524: AND wor.resource_id = br.resource_id
525: AND EXISTS
526: (SELECT null
527: FROM wip_operation_resources w3,
528: bom_resources br3
529: WHERE w3.wip_entity_id = i_wip_entity_id
530: AND w3.organization_id = i_org_id
531: AND w3.resource_seq_num = w.resource_seq_num

Line 548: UPDATE wip_operation_resources w

544: if (SQL%ROWCOUNT = 0) then
545: stmt_num := 121;
546: /* new final completion algorithm */
547: /* if Net is -ve, write to variance */
548: UPDATE wip_operation_resources w
549: SET
550: (relieved_res_final_comp_units,
551: relieved_variance_value,
552: temp_relieved_value

Line 574: FROM wip_operation_resources w2

570: nvl(applied_resource_value,0)-
571: nvl(relieved_res_completion_value,0)-
572: nvl(relieved_variance_value,0)-
573: nvl(relieved_res_scrap_value,0)
574: FROM wip_operation_resources w2
575: WHERE
576: w.wip_entity_id = w2.wip_entity_id and
577: w.organization_id = w2.organization_id and
578: w.operation_seq_num = w2.operation_seq_num and

Line 585: FROM wip_operation_resources wor,

581: WHERE w.wip_entity_id = i_wip_entity_id
582: AND w.organization_id = i_org_id
583: AND EXISTS
584: (SELECT null
585: FROM wip_operation_resources wor,
586: bom_resources br
587: WHERE wor.wip_entity_id = i_wip_entity_id
588: AND wor.organization_id = i_org_id
589: AND wor.organization_id = br.organization_id

Line 593: FROM wip_operation_resources w3,

589: AND wor.organization_id = br.organization_id
590: AND wor.resource_id = br.resource_id
591: AND EXISTS
592: (SELECT null
593: FROM wip_operation_resources w3,
594: bom_resources br3
595: WHERE w3.wip_entity_id = i_wip_entity_id
596: AND w3.organization_id = i_org_id
597: AND w3.resource_seq_num = w.resource_seq_num

Line 981: UPDATE wip_operation_resources w

977: * flush out TL Resource costs and units ... *
978: *******************************************************/
979:
980: stmt_num := 190;
981: UPDATE wip_operation_resources w
982: SET
983: (relieved_res_completion_units,
984: relieved_res_completion_value,
985: temp_relieved_value

Line 1007: FROM wip_operation_resources w2

1003: nvl(applied_resource_value,0)-
1004: nvl(relieved_res_completion_value,0)-
1005: nvl(relieved_variance_value,0)-
1006: nvl(relieved_res_scrap_value,0)
1007: FROM wip_operation_resources w2
1008: WHERE
1009: w.wip_entity_id = w2.wip_entity_id and
1010: w.organization_id = w2.organization_id and
1011: w.operation_seq_num = w2.operation_seq_num and

Line 1018: FROM wip_operation_resources wor,

1014: WHERE w.wip_entity_id = i_wip_entity_id
1015: AND w.organization_id = i_org_id
1016: AND EXISTS
1017: (SELECT null
1018: FROM wip_operation_resources wor,
1019: bom_resources br
1020: WHERE wor.wip_entity_id = i_wip_entity_id
1021: AND wor.organization_id = i_org_id
1022: AND wor.organization_id = br.organization_id

Line 1026: FROM wip_operation_resources w3,

1022: AND wor.organization_id = br.organization_id
1023: AND wor.resource_id = br.resource_id
1024: AND EXISTS
1025: (SELECT null
1026: FROM wip_operation_resources w3,
1027: bom_resources br3
1028: WHERE w3.wip_entity_id = i_wip_entity_id
1029: AND w3.organization_id = i_org_id
1030: AND w3.resource_seq_num = w.resource_seq_num

Line 1702: UPDATE wip_operation_resources w1

1698: -- both resources and overheads.
1699:
1700: stmt_num := 290;
1701:
1702: UPDATE wip_operation_resources w1
1703: SET
1704: (relieved_res_completion_units,
1705: temp_relieved_value,
1706: relieved_res_completion_value) =

Line 1774: wip_operation_resources w2,

1770: nvl(prior_scrap_quantity,0)),
1771: 1),
1772: 0)
1773: FROM
1774: wip_operation_resources w2,
1775: cst_comp_snapshot cocd
1776: WHERE
1777: w1.wip_entity_id = w2.wip_entity_id AND
1778: w1.operation_seq_num = w2.operation_seq_num AND

Line 1887: UPDATE wip_operation_resources w1

1883: -- the pre defined rates for resources and overheads.
1884:
1885: stmt_num := 300;
1886:
1887: UPDATE wip_operation_resources w1
1888: SET
1889: (relieved_res_completion_units,
1890: temp_relieved_value,
1891: relieved_res_completion_value) =

Line 2060: wip_operation_resources w2,

2056: 2,usage_rate_or_amount/l_lot_size,
2057: usage_rate_or_amount)*
2058: crc.resource_rate))
2059: FROM
2060: wip_operation_resources w2,
2061: cst_resource_costs crc
2062: WHERE
2063: w2.wip_entity_id = w1.wip_entity_id AND
2064: w2.operation_seq_num = w1.operation_seq_num AND

Line 2391: WIP_OPERATION_RESOURCES WOR,

2387: SYSDATE,
2388: SYSDATE
2389: FROM
2390: WIP_OPERATIONS WO,
2391: WIP_OPERATION_RESOURCES WOR,
2392: CST_DEPARTMENT_OVERHEADS CDO,
2393: CST_RESOURCE_OVERHEADS CRO
2394: WHERE
2395: WO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 2599: wip_operation_resources wor,

2595: FROM
2596: wip_operation_overheads w2,
2597: cst_department_overheads cdo,
2598: wip_operations wo,
2599: wip_operation_resources wor,
2600: cst_resource_overheads cro
2601: WHERE
2602: w2.wip_entity_id = w1.wip_entity_id AND
2603: w2.organization_id = w1.organization_id AND

Line 2633: wip_operation_resources wor2

2629: FROM
2630: cst_department_overheads cdo2,
2631: wip_operations wo2,
2632: cst_resource_overheads cro2,
2633: wip_operation_resources wor2
2634: WHERE
2635: w1.wip_entity_id = wo2.wip_entity_id AND
2636: w1.organization_id = wo2.organization_id AND
2637: w1.operation_seq_num = wo2.operation_seq_num AND

Line 2879: WIP_OPERATION_RESOURCES WOR

2875: i_prog_id,
2876: SYSDATE
2877: FROM
2878: BOM_RESOURCES BR,
2879: WIP_OPERATION_RESOURCES WOR
2880: WHERE
2881: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
2882: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
2883: WOR.WIP_ENTITY_ID = i_wip_entity_id AND

Line 3513: UPDATE WIP_OPERATION_RESOURCES

3509: WIP_ENTITY_ID = i_wip_entity_id;
3510:
3511: stmt_num := 20;
3512:
3513: UPDATE WIP_OPERATION_RESOURCES
3514: SET temp_relieved_value = 0
3515: where
3516: WIP_ENTITY_ID = i_wip_entity_id;
3517:

Line 3591: FROM wip_operation_resources wor

3587: WHERE wro.wip_entity_id = i_wip_entity_id
3588: AND wro.quantity_per_assembly <>0
3589: UNION ALL
3590: SELECT NULL
3591: FROM wip_operation_resources wor
3592: WHERE wor.wip_entity_id = i_wip_entity_id
3593: AND wor.usage_rate_or_amount <>0
3594: );
3595:

Line 4141: UPDATE wip_operation_resources w1

4137: -- snapshot table.
4138:
4139: stmt_num := 160;
4140:
4141: UPDATE wip_operation_resources w1
4142: SET
4143: (relieved_res_completion_units,
4144: temp_relieved_value,
4145: relieved_res_completion_value) =

Line 4180: wip_operation_resources w2,

4176: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
4177: prior_completion_quantity)),
4178: 0)
4179: FROM
4180: wip_operation_resources w2,
4181: cst_comp_snapshot cocd
4182: WHERE
4183: w2.wip_entity_id = w1.wip_entity_id AND
4184: w2.organization_id = w1.organization_id AND

Line 4366: WIP_OPERATION_RESOURCES WOR

4362: i_prog_id,
4363: SYSDATE
4364: FROM
4365: BOM_RESOURCES BR,
4366: WIP_OPERATION_RESOURCES WOR
4367: WHERE
4368: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
4369: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
4370: WOR.WIP_ENTITY_ID = i_wip_entity_id AND