[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:
735:
736:
737: stmt_num := 145;
738:
739: UPDATE wip_operation_overheads w1
740: SET
741: (relieved_ovhd_scrap_units,
742: temp_relieved_value,
743: relieved_ovhd_scrap_value) =
804: nvl(prior_scrap_quantity,0)),
805: 1),
806: 0)
807: FROM
808: wip_operation_overheads W2,
809: cst_comp_snapshot COCD
810: WHERE
811: w1.wip_entity_id = w2.wip_entity_id AND
812: w1.operation_seq_num = w2.operation_seq_num AND
1059: -- been charged then they must be relieved at the cost in the
1060: -- rates cost type. However, if nothing has been charged, there are
1061: -- no rows in WOO. So insert these rows.
1062:
1063: INSERT INTO WIP_OPERATION_OVERHEADS
1064: (WIP_ENTITY_ID,
1065: OPERATION_SEQ_NUM,
1066: RESOURCE_SEQ_NUM,
1067: ORGANIZATION_ID,
1117: WO.OPERATION_SEQ_NUM <= i_op_seq_num AND
1118: NOT EXISTS
1119: (SELECT 'X'
1120: FROM
1121: WIP_OPERATION_OVERHEADS WOO
1122: where
1123: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
1124: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
1125: WOO.OVERHEAD_ID = CDO.OVERHEAD_ID AND
1127: WOO.RESOURCE_SEQ_NUM = -1);
1128:
1129: stmt_num := 190;
1130:
1131: UPDATE wip_operation_overheads w1
1132: SET
1133: (relieved_ovhd_scrap_units,
1134: temp_relieved_value,
1135: relieved_ovhd_scrap_value) =
1293: decode(w2.basis_type,
1294: 1,i_txn_qty,
1295: 2,i_txn_qty/i_lot_size)))
1296: FROM
1297: wip_operation_overheads w2,
1298: cst_department_overheads cdo,
1299: wip_operations wo
1300: WHERE
1301: w2.wip_entity_id = w1.wip_entity_id AND
1333: cdo2.cost_type_id = i_res_cost_type_id);
1334:
1335:
1336: /**********************************************************
1337: * There may be overheads in wip_operation_overheads whose *
1338: * Basis may be different from thatin cst_dept_ovhds ,so *
1339: * we need to relieve these anyway if there is value to re-*
1340: * lieve. - OPEN ISSUE - DO WE DO THIS OR NOT?? *
1341: **********************************************************/
1342:
1343:
1344: stmt_num := 210;
1345:
1346: UPDATE WIP_OPERATION_OVERHEADS w1
1347: set
1348: (relieved_ovhd_scrap_units,
1349: temp_relieved_value,
1350: relieved_ovhd_scrap_value) =
1488: )*0
1489: ),
1490: 0))
1491: FROM
1492: WIP_OPERATION_OVERHEADS w2
1493: WHERE
1494: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1495: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1496: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND
1524: ***********************************************************/
1525:
1526: stmt_num := 225;
1527:
1528: INSERT INTO WIP_OPERATION_OVERHEADS
1529: (WIP_ENTITY_ID,
1530: OPERATION_SEQ_NUM,
1531: RESOURCE_SEQ_NUM,
1532: ORGANIZATION_ID,
1591: WO.OPERATION_SEQ_NUM <= i_op_seq_num AND
1592: NOT EXISTS
1593: (SELECT 'X'
1594: FROM
1595: WIP_OPERATION_OVERHEADS WOO
1596: WHERE
1597: WOO.WIP_ENTITY_ID = i_wip_entity_id AND
1598: WOO.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM AND
1599: WOO.RESOURCE_SEQ_NUM = WOR.RESOURCE_SEQ_NUM AND
1601: WOO.BASIS_TYPE = CDO.BASIS_TYPE);
1602:
1603: stmt_num := 230;
1604:
1605: UPDATE wip_operation_overheads w1
1606: SET
1607: (relieved_ovhd_scrap_units,
1608: temp_relieved_value,
1609: relieved_ovhd_scrap_value) =
1808: 1,wor.usage_rate_or_amount,
1809: 2,wor.usage_rate_or_amount/i_lot_size),
1810: 4,nvl(wor.temp_relieved_value,0))))
1811: FROM
1812: wip_operation_overheads w2,
1813: cst_department_overheads cdo,
1814: wip_operations wo,
1815: wip_operation_resources wor,
1816: cst_resource_overheads cro
1877: ************************************************************/
1878:
1879: stmt_num := 250;
1880:
1881: UPDATE wip_operation_overheads w1
1882: SET
1883: (relieved_ovhd_scrap_units,
1884: temp_relieved_value,
1885: relieved_ovhd_scrap_value) =
2000: nvl(relieved_ovhd_scrap_value,0)+
2001: 0),
2002: 0))
2003: FROM
2004: WIP_OPERATION_OVERHEADS w2,
2005: WIP_OPERATION_RESOURCES WOR
2006: WHERE
2007: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2008: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2130: -1,
2131: -1,
2132: SYSDATE
2133: FROM
2134: WIP_OPERATION_OVERHEADS
2135: WHERE
2136: wip_entity_id = i_wip_entity_id AND
2137: organization_id = i_org_id
2138: HAVING
2245: WIP_ENTITY_ID = i_wip_entity_id;
2246:
2247: stmt_num := 30;
2248:
2249: UPDATE WIP_OPERATION_OVERHEADS
2250: SET temp_relieved_value = 0
2251: where
2252: WIP_ENTITY_ID = i_wip_entity_id;
2253:
2491:
2492:
2493: stmt_num := 155;
2494:
2495: UPDATE wip_operation_overheads W1
2496: SET
2497: (RELIEVED_ovhd_SCRAP_UNITS,
2498: TEMP_RELIEVED_VALUE,
2499: RELIEVED_ovhd_scrap_value) =
2512: decode(abs(i_txn_qty),
2513: PRIOR_SCRAP_QUANTITY,-1,
2514: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
2515: FROM
2516: wip_operation_overheads W2,
2517: cst_comp_snapshot COCD
2518: WHERE
2519: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2520: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2612: *********************************************************/
2613:
2614: stmt_num := 200;
2615:
2616: UPDATE WIP_OPERATION_OVERHEADS W1
2617: SET
2618: (RELIEVED_OVHD_SCRAP_UNITS,
2619: TEMP_RELIEVED_VALUE,
2620: RELIEVED_OVHD_SCRAP_VALUE) =
2662: -1*nvl(relieved_ovhd_scrap_value,0),
2663: -1,
2664: 0)
2665: FROM
2666: WIP_OPERATION_OVERHEADS W2
2667: WHERE
2668: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
2669: W1.ORGANIZATION_ID = W2.ORGANIZATION_ID AND
2670: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND
2684:
2685: stmt_num := 220;
2686:
2687:
2688: UPDATE WIP_OPERATION_OVERHEADS W1
2689: SET
2690: (RELIEVED_OVHD_SCRAP_UNITS,
2691: TEMP_RELIEVED_VALUE,
2692: RELIEVED_OVHD_SCRAP_VALUE) =
2742: -1*nvl(relieved_ovhd_scrap_value,0),
2743: -1*SIGN(wor.usage_rate_or_amount),
2744: 0)
2745: FROM
2746: WIP_OPERATION_OVERHEADS W2,
2747: WIP_OPERATION_RESOURCES WOR
2748: where
2749: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2750: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2846: -1,
2847: -1,
2848: SYSDATE
2849: FROM
2850: WIP_OPERATION_OVERHEADS
2851: WHERE
2852: WIP_ENTITY_ID = i_wip_entity_id AND
2853: ORGANIZATION_ID = i_org_id
2854: HAVING