[Home] [Help]
66: WIP_ENTITY_ID = i_wip_entity_id;
67:
68: stmt_num := 30;
69:
70: UPDATE WIP_OPERATION_OVERHEADS
71: SET temp_relieved_value = 0
72: where
73: WIP_ENTITY_ID = i_wip_entity_id;
74:
676:
677:
678: stmt_num := 145;
679:
680: UPDATE wip_operation_overheads w1
681: SET
682: (relieved_ovhd_scrap_units,
683: temp_relieved_value,
684: relieved_ovhd_scrap_value) =
745: nvl(prior_scrap_quantity,0)),
746: 1),
747: 0)
748: FROM
749: wip_operation_overheads W2,
750: cst_comp_snapshot COCD
751: WHERE
752: w1.wip_entity_id = w2.wip_entity_id AND
753: w1.operation_seq_num = w2.operation_seq_num AND
977: -- been charged then they must be relieved at the cost in the
978: -- rates cost type. However, if nothing has been charged, there are
979: -- no rows in WOO. So insert these rows.
980:
981: INSERT INTO WIP_OPERATION_OVERHEADS
982: (WIP_ENTITY_ID,
983: OPERATION_SEQ_NUM,
984: RESOURCE_SEQ_NUM,
985: ORGANIZATION_ID,
1035: WO.OPERATION_SEQ_NUM <= i_op_seq_num AND
1036: NOT EXISTS
1037: (SELECT 'X'
1038: FROM
1039: WIP_OPERATION_OVERHEADS WOO
1040: where
1041: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
1042: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
1043: WOO.OVERHEAD_ID = CDO.OVERHEAD_ID AND
1045: WOO.RESOURCE_SEQ_NUM = -1);
1046:
1047: stmt_num := 190;
1048:
1049: UPDATE wip_operation_overheads w1
1050: SET
1051: (relieved_ovhd_scrap_units,
1052: temp_relieved_value,
1053: relieved_ovhd_scrap_value) =
1189: decode(w2.basis_type,
1190: 1,i_txn_qty,
1191: 2,i_txn_qty/i_lot_size)))
1192: FROM
1193: wip_operation_overheads w2,
1194: cst_department_overheads cdo,
1195: wip_operations wo
1196: WHERE
1197: w2.wip_entity_id = w1.wip_entity_id AND
1229: cdo2.cost_type_id = i_res_cost_type_id);
1230:
1231:
1232: /**********************************************************
1233: * There may be overheads in wip_operation_overheads whose *
1234: * Basis may be different from thatin cst_dept_ovhds ,so *
1235: * we need to relieve these anyway if there is value to re-*
1236: * lieve. - OPEN ISSUE - DO WE DO THIS OR NOT?? *
1237: **********************************************************/
1238:
1239:
1240: stmt_num := 210;
1241:
1242: UPDATE WIP_OPERATION_OVERHEADS w1
1243: set
1244: (relieved_ovhd_scrap_units,
1245: temp_relieved_value,
1246: relieved_ovhd_scrap_value) =
1366: nvl(relieved_ovhd_scrap_units,0)))*
1367: 0),
1368: 0))
1369: FROM
1370: WIP_OPERATION_OVERHEADS w2
1371: WHERE
1372: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1373: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1374: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND
1402: ***********************************************************/
1403:
1404: stmt_num := 225;
1405:
1406: INSERT INTO WIP_OPERATION_OVERHEADS
1407: (WIP_ENTITY_ID,
1408: OPERATION_SEQ_NUM,
1409: RESOURCE_SEQ_NUM,
1410: ORGANIZATION_ID,
1467: WO.OPERATION_SEQ_NUM <= i_op_seq_num AND
1468: NOT EXISTS
1469: (SELECT 'X'
1470: FROM
1471: WIP_OPERATION_OVERHEADS WOO
1472: WHERE
1473: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
1474: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
1475: WOO.RESOURCE_SEQ_NUM = WOR.RESOURCE_SEQ_NUM AND
1477: WOO.BASIS_TYPE = CDO.BASIS_TYPE);
1478:
1479: stmt_num := 230;
1480:
1481: UPDATE wip_operation_overheads w1
1482: SET
1483: (relieved_ovhd_scrap_units,
1484: temp_relieved_value,
1485: relieved_ovhd_scrap_value) =
1656: 1,wor.usage_rate_or_amount,
1657: 2,wor.usage_rate_or_amount/i_lot_size),
1658: 4,nvl(wor.temp_relieved_value,0))))
1659: FROM
1660: wip_operation_overheads w2,
1661: cst_department_overheads cdo,
1662: wip_operations wo,
1663: wip_operation_resources wor,
1664: cst_resource_overheads cro
1721: ************************************************************/
1722:
1723: stmt_num := 250;
1724:
1725: UPDATE wip_operation_overheads w1
1726: SET
1727: (relieved_ovhd_scrap_units,
1728: temp_relieved_value,
1729: relieved_ovhd_scrap_value) =
1846: nvl(relieved_ovhd_scrap_value,0)+
1847: 0),
1848: 0))
1849: FROM
1850: WIP_OPERATION_OVERHEADS w2,
1851: WIP_OPERATION_RESOURCES WOR
1852: WHERE
1853: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1854: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1974: -1,
1975: -1,
1976: SYSDATE
1977: FROM
1978: WIP_OPERATION_OVERHEADS
1979: WHERE
1980: wip_entity_id = i_wip_entity_id AND
1981: organization_id = i_org_id
1982: HAVING
2089: WIP_ENTITY_ID = i_wip_entity_id;
2090:
2091: stmt_num := 30;
2092:
2093: UPDATE WIP_OPERATION_OVERHEADS
2094: SET temp_relieved_value = 0
2095: where
2096: WIP_ENTITY_ID = i_wip_entity_id;
2097:
2334:
2335:
2336: stmt_num := 155;
2337:
2338: UPDATE wip_operation_overheads W1
2339: SET
2340: (RELIEVED_ovhd_SCRAP_UNITS,
2341: TEMP_RELIEVED_VALUE,
2342: RELIEVED_ovhd_scrap_value) =
2355: decode(abs(i_txn_qty),
2356: PRIOR_SCRAP_QUANTITY,-1,
2357: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
2358: FROM
2359: wip_operation_overheads W2,
2360: cst_comp_snapshot COCD
2361: WHERE
2362: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2363: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2454: *********************************************************/
2455:
2456: stmt_num := 200;
2457:
2458: UPDATE WIP_OPERATION_OVERHEADS W1
2459: SET
2460: (RELIEVED_OVHD_SCRAP_UNITS,
2461: TEMP_RELIEVED_VALUE,
2462: RELIEVED_OVHD_SCRAP_VALUE) =
2504: -1*nvl(relieved_ovhd_scrap_value,0),
2505: -1,
2506: 0)
2507: FROM
2508: WIP_OPERATION_OVERHEADS W2
2509: WHERE
2510: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
2511: W1.ORGANIZATION_ID = W2.ORGANIZATION_ID AND
2512: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND
2526:
2527: stmt_num := 220;
2528:
2529:
2530: UPDATE WIP_OPERATION_OVERHEADS W1
2531: SET
2532: (RELIEVED_OVHD_SCRAP_UNITS,
2533: TEMP_RELIEVED_VALUE,
2534: RELIEVED_OVHD_SCRAP_VALUE) =
2584: -1*nvl(relieved_ovhd_scrap_value,0),
2585: -1*SIGN(wor.usage_rate_or_amount),
2586: 0)
2587: FROM
2588: WIP_OPERATION_OVERHEADS W2,
2589: WIP_OPERATION_RESOURCES WOR
2590: where
2591: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2592: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2688: -1,
2689: -1,
2690: SYSDATE
2691: FROM
2692: WIP_OPERATION_OVERHEADS
2693: WHERE
2694: WIP_ENTITY_ID = i_wip_entity_id AND
2695: ORGANIZATION_ID = i_org_id
2696: HAVING