[Home] [Help]
92: sysdate
93: FROM
94: cst_department_overheads CDO,
95: cst_resource_overheads CRO,
96: wip_operation_resources WOR,
97: wip_operations WO
98: WHERE
99: WO.wip_entity_id = p_wip_entity_id
100: AND WOR.wip_entity_id = WO.wip_entity_id
3152: INTO
3153: x_tl_res_cost,
3154: x_tl_osp_cost
3155: FROM cst_resource_costs CRC,
3156: wip_operation_resources WOR,
3157: bom_resources BR
3158: WHERE
3159: CRC.COST_TYPE_ID(+) = 1
3160: AND CRC.RESOURCE_ID(+) = WOR.RESOURCE_ID
3196: INTO
3197: x_tl_ovh_cost
3198: FROM
3199: wip_operations WO,
3200: wip_operation_resources WOR,
3201: cst_resource_overheads CRO,
3202: cst_department_overheads CDO,
3203: bom_resources BR,
3204: cst_resource_costs CRC
3248: 2, SUM(NVL(WOO.relieved_ovhd_value,0))),0)
3249: INTO x_tl_ovh_cost
3250: FROM wip_operation_overheads WOO,
3251: cst_resource_overheads CRO,
3252: wip_operation_resources WOR
3253: WHERE
3254: WOO.operation_seq_num <= l_operation_seq_num
3255: AND WOO.wip_entity_id = p_entity_id
3256: AND WOO.organization_id = p_org_id
3459: /* Update applied resource units and applied resource value. */
3460: l_stmt_num := 40;
3461:
3462:
3463: UPDATE wip_operation_resources wor
3464: SET wor.applied_resource_units = ROUND((C_result.start_quantity *
3465: decode(wor.basis_type,
3466: 1,wor.usage_rate_or_amount,
3467: 2,wor.usage_rate_or_amount/C_result.start_quantity,
3517: decode(woo.basis_type,
3518: 3, NVL(CDO.rate_or_amount* WOR.applied_resource_units,0),
3519: 4, NVL(CDO.rate_or_amount*
3520: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3521: FROM wip_operation_resources WOR,
3522: cst_resource_overheads CRO,
3523: cst_department_overheads CDO,
3524: wip_operations WO
3525: WHERE
3598: l_stmt_num := 70;
3599:
3600: l_scale_factor := C_rec.start_quantity/l_available_quantity;
3601:
3602: UPDATE wip_operation_resources wor
3603: SET ( wor.applied_resource_units,
3604: wor.applied_resource_value ) =
3605: ( SELECT (nvl(wor1.applied_resource_units, 0) - DECODE(sign(nvl(wor1.relieved_res_units, 0)), 1, nvl(wor1.relieved_res_units, 0), 0)) *
3606: DECODE(sign(nvl(wor1.applied_resource_units, 0) - DECODE(sign(nvl(wor1.relieved_res_units, 0)), 1, nvl(wor1.relieved_res_units, 0), 0)),
3607: 1, 1, 0),
3608: (nvl(wor1.applied_resource_value,0) - DECODE(sign(nvl(wor1.relieved_res_value, 0)), 1, nvl(wor1.relieved_res_value, 0), 0)) *
3609: DECODE(sign(nvl(wor1.applied_resource_value,0) - DECODE(sign(nvl(wor1.relieved_res_value, 0)), 1, nvl(wor1.relieved_res_value, 0), 0)),
3610: 1, 1, 0)
3611: FROM wip_operation_resources wor1
3612: WHERE wor1.operation_seq_num = wor.operation_seq_num
3613: AND wor1.wip_entity_id = l_rep_wip_entity_id
3614: AND wor1.organization_id = wor.organization_id
3615: AND wor1.resource_seq_num = wor.resource_seq_num )
3624: and wo.operation_seq_num = wor.operation_seq_num
3625: and wo.disable_date <= l_transaction_date )
3626: /* Make sure the operation exists in the Parent */
3627: AND exists (select 'operation exists'
3628: from wip_operation_resources wor2
3629: WHERE wor2.operation_seq_num = wor.operation_seq_num
3630: AND wor2.wip_entity_id = l_rep_wip_entity_id
3631: AND wor2.organization_id = wor.organization_id
3632: AND wor2.resource_seq_num = wor.resource_seq_num);
3725: END IF;
3726:
3727: l_stmt_num := 92;
3728:
3729: UPDATE wip_operation_resources wor
3730: SET wor.applied_resource_units = wor.applied_resource_units * l_scale_factor,
3731: wor.applied_resource_value = wor.applied_resource_value * l_scale_factor
3732: WHERE wor.wip_entity_id = C_rec1.wip_entity_id
3733: AND wor.organization_id = l_org_id
3774: decode(woo.basis_type,
3775: 3, NVL(CDO.rate_or_amount* NVL(WOR.applied_resource_units, 0) , 0),
3776: 4, NVL(CDO.rate_or_amount*
3777: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3778: FROM wip_operation_resources WOR,
3779: cst_resource_overheads CRO,
3780: cst_department_overheads CDO,
3781: wip_operations WO
3782: WHERE
3813: FND_FILE.put_line(fnd_file.log,'Updating Resulting Job that is part of Start Job:(App-Rel)*F + Rel: '||to_char(l_resulting_scale_factor));
3814: END IF;
3815: l_stmt_num := 100;
3816:
3817: UPDATE wip_operation_resources wor
3818: SET wor.applied_resource_units = (NVL(wor.applied_resource_units,0) -
3819: DECODE(sign(nvl(wor.relieved_res_units, 0)), 1, nvl(wor.relieved_res_units, 0), 0))
3820: * l_resulting_scale_factor +
3821: DECODE(sign(nvl(wor.relieved_res_units, 0)), 1, nvl(wor.relieved_res_units, 0), 0),
3879: decode(woo.basis_type,
3880: 3, NVL(CDO.rate_or_amount* WOR.applied_resource_units,0),
3881: 4, NVL(CDO.rate_or_amount*
3882: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3883: FROM wip_operation_resources WOR,
3884: cst_resource_overheads CRO,
3885: cst_department_overheads CDO,
3886: wip_operations WO
3887: WHERE
3939: END IF;
3940:
3941: l_stmt_num := 120;
3942:
3943: UPDATE wip_operation_resources wor
3944: SET applied_resource_units = round(DECODE(sign(nvl(relieved_res_units, 0)), 1, nvl(relieved_res_units, 0), 0),6),
3945: applied_resource_value = round(DECODE(sign(nvl(relieved_res_value, 0)), 1, nvl(relieved_res_value, 0), 0),6)
3946: WHERE wip_entity_id = S_rec.wip_entity_id
3947: AND nvl(applied_resource_units, 0) >= nvl(relieved_res_units, 0)