[Home] [Help]
839:
840:
841: l_stmt_num := 200;
842:
843: UPDATE wip_operation_overheads w1
844: SET
845: (relieved_ovhd_completion_units,
846: temp_relieved_value,
847: relieved_ovhd_completion_value) =
908: nvl(prior_scrap_quantity,0)),
909: 1),
910: 0)
911: FROM
912: wip_operation_overheads w2,
913: cst_comp_snapshot cocd
914: WHERE
915: w1.wip_entity_id = w2.wip_entity_id AND
916: w1.operation_seq_num = w2.operation_seq_num AND
1089: i_prog_appl_id,
1090: i_prog_id,
1091: SYSDATE
1092: FROM
1093: WIP_OPERATION_OVERHEADS
1094: WHERE
1095: WIP_ENTITY_ID = i_wip_entity_id AND
1096: ORGANIZATION_ID = i_org_id
1097: HAVING
1801:
1802:
1803: l_stmt_num := 130;
1804:
1805: UPDATE wip_operation_overheads w1
1806: SET
1807: (relieved_ovhd_completion_units,
1808: temp_relieved_value,
1809: relieved_ovhd_completion_value) =
1842: prior_completion_quantity)),
1843: 0)
1844:
1845: FROM
1846: wip_operation_overheads w2,
1847: cst_comp_snapshot cocd
1848: WHERE
1849: w2.wip_entity_id = w1.wip_entity_id AND
1850: w2.organization_id = w1.organization_id AND
2012: i_prog_appl_id,
2013: i_prog_id,
2014: SYSDATE
2015: FROM
2016: WIP_OPERATION_OVERHEADS
2017: WHERE
2018: WIP_ENTITY_ID = i_wip_entity_id AND
2019: ORGANIZATION_ID = i_org_id
2020: HAVING