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_OVERHEADS

Line 151: UPDATE WIP_OPERATION_OVERHEADS

147: ORGANIZATION_ID = i_org_id;
148:
149: stmt_num := 30;
150:
151: UPDATE WIP_OPERATION_OVERHEADS
152: SET temp_relieved_value = 0
153: WHERE
154: WIP_ENTITY_ID = i_wip_entity_id AND
155: ORGANIZATION_ID = i_org_id;

Line 620: UPDATE wip_operation_overheads w

616:
617: stmt_num := 132;
618:
619: /* flush out TL Overhead move based resources based */
620: UPDATE wip_operation_overheads w
621: set (relieved_ovhd_completion_units,
622: relieved_ovhd_completion_value,
623: temp_relieved_value) =
624: (SELECT

Line 645: wip_operation_overheads w2

641: nvl(relieved_ovhd_completion_value,0)-
642: nvl(relieved_variance_value,0)-
643: nvl(relieved_ovhd_scrap_value,0)
644: FROM
645: wip_operation_overheads w2
646: where
647: w.wip_entity_id = w2.wip_entity_id AND
648: w.organization_id = w2.organization_id AND
649: w.operation_seq_num = w2.operation_seq_num AND

Line 659: FROM wip_operation_overheads woo

655: w.wip_entity_id = i_wip_entity_id AND
656: w.organization_id = i_org_id
657: AND exists (
658: SELECT 'x'
659: FROM wip_operation_overheads woo
660: WHERE woo.wip_entity_id = w.wip_entity_id
661: AND woo.organization_id = w.organization_id
662: HAVING sum(nvl(applied_ovhd_value,0) -
663: nvl(relieved_ovhd_completion_value,0) -

Line 674: UPDATE wip_operation_overheads w

670: if (SQL%ROWCOUNT = 0) then
671: stmt_num := 133;
672: /* New final completion algorithm */
673: /* for net value of overhead is -ve, write to variance */
674: UPDATE wip_operation_overheads w
675: set (relieved_ovhd_final_comp_units,
676: relieved_variance_value,
677: temp_relieved_value) =
678: (SELECT

Line 699: wip_operation_overheads w2

695: nvl(relieved_ovhd_completion_value,0)-
696: nvl(relieved_variance_value,0)-
697: nvl(relieved_ovhd_scrap_value,0)
698: FROM
699: wip_operation_overheads w2
700: where
701: w.wip_entity_id = w2.wip_entity_id AND
702: w.organization_id = w2.organization_id AND
703: w.operation_seq_num = w2.operation_seq_num AND

Line 713: FROM wip_operation_overheads woo

709: w.wip_entity_id = i_wip_entity_id AND
710: w.organization_id = i_org_id
711: AND exists (
712: SELECT 'x'
713: FROM wip_operation_overheads woo
714: WHERE woo.wip_entity_id = w.wip_entity_id
715: AND woo.organization_id = w.organization_id
716: HAVING sum(nvl(applied_ovhd_value,0) -
717: nvl(relieved_ovhd_completion_value,0) -

Line 1052: UPDATE wip_operation_overheads w

1048:
1049: stmt_num := 200;
1050:
1051: /* flush out TL Overhead move based resources based */
1052: UPDATE wip_operation_overheads w
1053: set (relieved_ovhd_completion_units,
1054: relieved_ovhd_completion_value,
1055: temp_relieved_value) =
1056: (SELECT

Line 1077: wip_operation_overheads w2

1073: nvl(relieved_ovhd_completion_value,0)-
1074: nvl(relieved_variance_value,0)-
1075: nvl(relieved_ovhd_scrap_value,0)
1076: FROM
1077: wip_operation_overheads w2
1078: where
1079: w.wip_entity_id = w2.wip_entity_id AND
1080: w.organization_id = w2.organization_id AND
1081: w.operation_seq_num = w2.operation_seq_num AND

Line 1091: FROM wip_operation_overheads woo

1087: w.wip_entity_id = i_wip_entity_id AND
1088: w.organization_id = i_org_id
1089: AND exists (
1090: SELECT 'x'
1091: FROM wip_operation_overheads woo
1092: WHERE woo.wip_entity_id = w.wip_entity_id
1093: AND woo.organization_id = w.organization_id
1094: HAVING sum(nvl(applied_ovhd_value,0) -
1095: nvl(relieved_ovhd_completion_value,0) -

Line 1793: UPDATE wip_operation_overheads w1

1789:
1790:
1791: stmt_num := 295;
1792:
1793: UPDATE wip_operation_overheads w1
1794: SET
1795: (relieved_ovhd_completion_units,
1796: temp_relieved_value,
1797: relieved_ovhd_completion_value) =

Line 1862: wip_operation_overheads w2,

1858: nvl(prior_scrap_quantity,0)),
1859: 1),
1860: 0)
1861: FROM
1862: wip_operation_overheads w2,
1863: cst_comp_snapshot cocd
1864: WHERE
1865: w1.wip_entity_id = w2.wip_entity_id AND
1866: w1.operation_seq_num = w2.operation_seq_num AND

Line 2090: INSERT INTO WIP_OPERATION_OVERHEADS

2086: -- been charged then they must be relieved at the cost in the
2087: -- rates cost type. However, if nothing has been charged, there are
2088: -- no rows in WOO. So insert these rows.
2089:
2090: INSERT INTO WIP_OPERATION_OVERHEADS
2091: (WIP_ENTITY_ID,
2092: OPERATION_SEQ_NUM,
2093: RESOURCE_SEQ_NUM,
2094: ORGANIZATION_ID,

Line 2147: WIP_OPERATION_OVERHEADS WOO

2143: CDO.BASIS_TYPE IN (1,2) AND
2144: NOT EXISTS
2145: (SELECT 'X'
2146: FROM
2147: WIP_OPERATION_OVERHEADS WOO
2148: where
2149: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
2150: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
2151: WOO.OVERHEAD_ID = CDO.OVERHEAD_ID AND

Line 2158: UPDATE wip_operation_overheads w1

2154:
2155:
2156: stmt_num := 310;
2157:
2158: UPDATE wip_operation_overheads w1
2159: SET
2160: (relieved_ovhd_completion_units,
2161: temp_relieved_value,
2162: relieved_ovhd_completion_value) =

Line 2302: wip_operation_overheads w2,

2298: decode(w2.basis_type,
2299: 1,i_txn_qty,
2300: 2,i_txn_qty/l_lot_size)))
2301: FROM
2302: wip_operation_overheads w2,
2303: cst_department_overheads cdo,
2304: wip_operations wo
2305: WHERE
2306: w2.wip_entity_id = w1.wip_entity_id AND

Line 2343: INSERT INTO WIP_OPERATION_OVERHEADS

2339: ***********************************************************/
2340:
2341: stmt_num := 320;
2342:
2343: INSERT INTO WIP_OPERATION_OVERHEADS
2344: (WIP_ENTITY_ID,
2345: OPERATION_SEQ_NUM,
2346: RESOURCE_SEQ_NUM,
2347: ORGANIZATION_ID,

Line 2407: WIP_OPERATION_OVERHEADS WOO

2403: CRO.OVERHEAD_ID = CDO.OVERHEAD_ID AND
2404: NOT EXISTS
2405: (SELECT 'X'
2406: FROM
2407: WIP_OPERATION_OVERHEADS WOO
2408: WHERE
2409: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
2410: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
2411: WOO.RESOURCE_SEQ_NUM = WOR.RESOURCE_SEQ_NUM AND

Line 2417: UPDATE wip_operation_overheads w1

2413: WOO.BASIS_TYPE = CDO.BASIS_TYPE);
2414:
2415: stmt_num := 330;
2416:
2417: UPDATE wip_operation_overheads w1
2418: SET
2419: (relieved_ovhd_completion_units,
2420: temp_relieved_value,
2421: relieved_ovhd_completion_value) =

Line 2596: wip_operation_overheads w2,

2592: 1,wor.usage_rate_or_amount,
2593: 2,wor.usage_rate_or_amount/l_lot_size),
2594: 4,nvl(wor.temp_relieved_value,0))))
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

Line 2930: WIP_OPERATION_OVERHEADS

2926: i_prog_appl_id,
2927: i_prog_id,
2928: SYSDATE
2929: FROM
2930: WIP_OPERATION_OVERHEADS
2931: WHERE
2932: WIP_ENTITY_ID = i_wip_entity_id AND
2933: ORGANIZATION_ID = i_org_id
2934: HAVING

Line 3520: UPDATE WIP_OPERATION_OVERHEADS

3516: WIP_ENTITY_ID = i_wip_entity_id;
3517:
3518: stmt_num := 30;
3519:
3520: UPDATE WIP_OPERATION_OVERHEADS
3521: SET temp_relieved_value = 0
3522: where
3523: WIP_ENTITY_ID = i_wip_entity_id;
3524:

Line 4199: UPDATE wip_operation_overheads w1

4195:
4196:
4197: stmt_num := 165;
4198:
4199: UPDATE wip_operation_overheads w1
4200: SET
4201: (relieved_ovhd_completion_units,
4202: temp_relieved_value,
4203: relieved_ovhd_completion_value) =

Line 4240: wip_operation_overheads w2,

4236: prior_completion_quantity)),
4237: 0)
4238:
4239: FROM
4240: wip_operation_overheads w2,
4241: cst_comp_snapshot cocd
4242: WHERE
4243: w2.wip_entity_id = w1.wip_entity_id AND
4244: w2.organization_id = w1.organization_id AND

Line 4417: WIP_OPERATION_OVERHEADS

4413: i_prog_appl_id,
4414: i_prog_id,
4415: SYSDATE
4416: FROM
4417: WIP_OPERATION_OVERHEADS
4418: WHERE
4419: WIP_ENTITY_ID = i_wip_entity_id AND
4420: ORGANIZATION_ID = i_org_id
4421: HAVING