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 1844: UPDATE wip_operation_overheads w1

1840:
1841:
1842: stmt_num := 295;
1843:
1844: UPDATE wip_operation_overheads w1
1845: SET
1846: (relieved_ovhd_completion_units,
1847: temp_relieved_value,
1848: relieved_ovhd_completion_value) =

Line 1913: wip_operation_overheads w2,

1909: nvl(prior_scrap_quantity,0)),
1910: 1),
1911: 0)
1912: FROM
1913: wip_operation_overheads w2,
1914: cst_comp_snapshot cocd
1915: WHERE
1916: w1.wip_entity_id = w2.wip_entity_id AND
1917: w1.operation_seq_num = w2.operation_seq_num AND

Line 2164: INSERT INTO WIP_OPERATION_OVERHEADS

2160: -- been charged then they must be relieved at the cost in the
2161: -- rates cost type. However, if nothing has been charged, there are
2162: -- no rows in WOO. So insert these rows.
2163:
2164: INSERT INTO WIP_OPERATION_OVERHEADS
2165: (WIP_ENTITY_ID,
2166: OPERATION_SEQ_NUM,
2167: RESOURCE_SEQ_NUM,
2168: ORGANIZATION_ID,

Line 2221: WIP_OPERATION_OVERHEADS WOO

2217: CDO.BASIS_TYPE IN (1,2) AND
2218: NOT EXISTS
2219: (SELECT 'X'
2220: FROM
2221: WIP_OPERATION_OVERHEADS WOO
2222: where
2223: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
2224: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
2225: WOO.OVERHEAD_ID = CDO.OVERHEAD_ID AND

Line 2232: UPDATE wip_operation_overheads w1

2228:
2229:
2230: stmt_num := 310;
2231:
2232: UPDATE wip_operation_overheads w1
2233: SET
2234: (relieved_ovhd_completion_units,
2235: temp_relieved_value,
2236: relieved_ovhd_completion_value) =

Line 2394: wip_operation_overheads w2,

2390: decode(w2.basis_type,
2391: 1,i_txn_qty,
2392: 2,i_txn_qty/l_lot_size)))
2393: FROM
2394: wip_operation_overheads w2,
2395: cst_department_overheads cdo,
2396: wip_operations wo
2397: WHERE
2398: w2.wip_entity_id = w1.wip_entity_id AND

Line 2435: INSERT INTO WIP_OPERATION_OVERHEADS

2431: ***********************************************************/
2432:
2433: stmt_num := 320;
2434:
2435: INSERT INTO WIP_OPERATION_OVERHEADS
2436: (WIP_ENTITY_ID,
2437: OPERATION_SEQ_NUM,
2438: RESOURCE_SEQ_NUM,
2439: ORGANIZATION_ID,

Line 2501: WIP_OPERATION_OVERHEADS WOO

2497: CRO.OVERHEAD_ID = CDO.OVERHEAD_ID AND
2498: NOT EXISTS
2499: (SELECT 'X'
2500: FROM
2501: WIP_OPERATION_OVERHEADS WOO
2502: WHERE
2503: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
2504: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
2505: WOO.RESOURCE_SEQ_NUM = WOR.RESOURCE_SEQ_NUM AND

Line 2511: UPDATE wip_operation_overheads w1

2507: WOO.BASIS_TYPE = CDO.BASIS_TYPE);
2508:
2509: stmt_num := 330;
2510:
2511: UPDATE wip_operation_overheads w1
2512: SET
2513: (relieved_ovhd_completion_units,
2514: temp_relieved_value,
2515: relieved_ovhd_completion_value) =

Line 2716: wip_operation_overheads w2,

2712: 1,wor.usage_rate_or_amount,
2713: 2,wor.usage_rate_or_amount/l_lot_size),
2714: 4,nvl(wor.temp_relieved_value,0))))
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

Line 3066: WIP_OPERATION_OVERHEADS

3062: i_prog_appl_id,
3063: i_prog_id,
3064: SYSDATE
3065: FROM
3066: WIP_OPERATION_OVERHEADS
3067: WHERE
3068: WIP_ENTITY_ID = i_wip_entity_id AND
3069: ORGANIZATION_ID = i_org_id
3070: HAVING

Line 3685: UPDATE WIP_OPERATION_OVERHEADS

3681: WIP_ENTITY_ID = i_wip_entity_id;
3682:
3683: stmt_num := 30;
3684:
3685: UPDATE WIP_OPERATION_OVERHEADS
3686: SET temp_relieved_value = 0
3687: where
3688: WIP_ENTITY_ID = i_wip_entity_id;
3689:

Line 4372: UPDATE wip_operation_overheads w1

4368:
4369:
4370: stmt_num := 165;
4371:
4372: UPDATE wip_operation_overheads w1
4373: SET
4374: (relieved_ovhd_completion_units,
4375: temp_relieved_value,
4376: relieved_ovhd_completion_value) =

Line 4413: wip_operation_overheads w2,

4409: prior_completion_quantity)),
4410: 0)
4411:
4412: FROM
4413: wip_operation_overheads w2,
4414: cst_comp_snapshot cocd
4415: WHERE
4416: w2.wip_entity_id = w1.wip_entity_id AND
4417: w2.organization_id = w1.organization_id AND

Line 4591: WIP_OPERATION_OVERHEADS

4587: i_prog_appl_id,
4588: i_prog_id,
4589: SYSDATE
4590: FROM
4591: WIP_OPERATION_OVERHEADS
4592: WHERE
4593: WIP_ENTITY_ID = i_wip_entity_id AND
4594: ORGANIZATION_ID = i_org_id
4595: HAVING