[Home] [Help]
91: sysdate,
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
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
3205: WHERE
3247: 1, SUM(NVL(WOO.applied_ovhd_value,0)),
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
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
3526: WOR.wip_entity_id = C_result.wip_entity_id
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
3783: WOR.wip_entity_id = C_rec1.wip_entity_id
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
3888: WOR.wip_entity_id = l_rep_wip_entity_id