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 1752: UPDATE wip_operation_resources w1

1748: -- both resources and overheads.
1749:
1750: stmt_num := 290;
1751:
1752: UPDATE wip_operation_resources w1
1753: SET
1754: (relieved_res_completion_units,
1755: temp_relieved_value,
1756: relieved_res_completion_value) =

Line 1824: wip_operation_resources w2,

1820: nvl(prior_scrap_quantity,0)),
1821: 1),
1822: 0)
1823: FROM
1824: wip_operation_resources w2,
1825: cst_comp_snapshot cocd
1826: WHERE
1827: w1.wip_entity_id = w2.wip_entity_id AND
1828: w1.operation_seq_num = w2.operation_seq_num AND

Line 1939: UPDATE wip_operation_resources w1

1935: -- the pre defined rates for resources and overheads.
1936:
1937: stmt_num := 300;
1938:
1939: UPDATE wip_operation_resources w1
1940: SET
1941: (relieved_res_completion_units,
1942: temp_relieved_value,
1943: relieved_res_completion_value) =

Line 2134: wip_operation_resources w2,

2130: 2,usage_rate_or_amount/l_lot_size,
2131: usage_rate_or_amount)*
2132: crc.resource_rate))
2133: FROM
2134: wip_operation_resources w2,
2135: cst_resource_costs crc
2136: WHERE
2137: w2.wip_entity_id = w1.wip_entity_id AND
2138: w2.operation_seq_num = w1.operation_seq_num AND

Line 2483: WIP_OPERATION_RESOURCES WOR,

2479: SYSDATE,
2480: SYSDATE
2481: FROM
2482: WIP_OPERATIONS WO,
2483: WIP_OPERATION_RESOURCES WOR,
2484: CST_DEPARTMENT_OVERHEADS CDO,
2485: CST_RESOURCE_OVERHEADS CRO
2486: WHERE
2487: WO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 2719: wip_operation_resources wor,

2715: FROM
2716: wip_operation_overheads w2,
2717: cst_department_overheads cdo,
2718: wip_operations wo,
2719: wip_operation_resources wor,
2720: cst_resource_overheads cro
2721: WHERE
2722: w2.wip_entity_id = w1.wip_entity_id AND
2723: w2.organization_id = w1.organization_id AND

Line 2755: wip_operation_resources wor2

2751: FROM
2752: cst_department_overheads cdo2,
2753: wip_operations wo2,
2754: cst_resource_overheads cro2,
2755: wip_operation_resources wor2
2756: WHERE
2757: w1.wip_entity_id = wo2.wip_entity_id AND
2758: w1.organization_id = wo2.organization_id AND
2759: w1.operation_seq_num = wo2.operation_seq_num AND

Line 3015: WIP_OPERATION_RESOURCES WOR

3011: i_prog_id,
3012: SYSDATE
3013: FROM
3014: BOM_RESOURCES BR,
3015: WIP_OPERATION_RESOURCES WOR
3016: WHERE
3017: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
3018: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
3019: WOR.WIP_ENTITY_ID = i_wip_entity_id AND

Line 3678: UPDATE WIP_OPERATION_RESOURCES

3674: WIP_ENTITY_ID = i_wip_entity_id;
3675:
3676: stmt_num := 20;
3677:
3678: UPDATE WIP_OPERATION_RESOURCES
3679: SET temp_relieved_value = 0
3680: where
3681: WIP_ENTITY_ID = i_wip_entity_id;
3682:

Line 3756: FROM wip_operation_resources wor

3752: WHERE wro.wip_entity_id = i_wip_entity_id
3753: AND wro.quantity_per_assembly <>0
3754: UNION ALL
3755: SELECT NULL
3756: FROM wip_operation_resources wor
3757: WHERE wor.wip_entity_id = i_wip_entity_id
3758: AND wor.usage_rate_or_amount <>0
3759: );
3760:

Line 4313: UPDATE wip_operation_resources w1

4309: -- snapshot table.
4310:
4311: stmt_num := 160;
4312:
4313: UPDATE wip_operation_resources w1
4314: SET
4315: (relieved_res_completion_units,
4316: temp_relieved_value,
4317: relieved_res_completion_value) =

Line 4352: wip_operation_resources w2,

4348: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
4349: prior_completion_quantity)),
4350: 0)
4351: FROM
4352: wip_operation_resources w2,
4353: cst_comp_snapshot cocd
4354: WHERE
4355: w2.wip_entity_id = w1.wip_entity_id AND
4356: w2.organization_id = w1.organization_id AND

Line 4540: WIP_OPERATION_RESOURCES WOR

4536: i_prog_id,
4537: SYSDATE
4538: FROM
4539: BOM_RESOURCES BR,
4540: WIP_OPERATION_RESOURCES WOR
4541: WHERE
4542: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
4543: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
4544: WOR.WIP_ENTITY_ID = i_wip_entity_id AND