2133: -1,
2134: SYSDATE,
2135: SYSDATE
2136: FROM
2137: WIP_OPERATIONS WO,
2138: CST_DEPARTMENT_OVERHEADS CDO
2139: WHERE
2140: WO.WIP_ENTITY_ID = i_wip_entity_id AND
2141: WO.DEPARTMENT_ID = CDO.DEPARTMENT_ID AND
2300: 2,i_txn_qty/l_lot_size)))
2301: FROM
2302: wip_operation_overheads w2,
2303: cst_department_overheads cdo,
2304: wip_operations wo
2305: WHERE
2306: w2.wip_entity_id = w1.wip_entity_id AND
2307: w2.organization_id = w1.organization_id AND
2308: w2.operation_seq_num = w1.operation_seq_num AND
2323: (
2324: SELECT 'X'
2325: FROM
2326: cst_department_overheads cdo2,
2327: wip_operations wo2
2328: WHERE
2329: wo2.wip_entity_id = w1.wip_entity_id AND
2330: wo2.organization_id = w1.organization_id AND
2331: wo2.operation_seq_num = w1.operation_seq_num AND
2386: -1,
2387: SYSDATE,
2388: SYSDATE
2389: FROM
2390: WIP_OPERATIONS WO,
2391: WIP_OPERATION_RESOURCES WOR,
2392: CST_DEPARTMENT_OVERHEADS CDO,
2393: CST_RESOURCE_OVERHEADS CRO
2394: WHERE
2594: 4,nvl(wor.temp_relieved_value,0))))
2595: FROM
2596: wip_operation_overheads w2,
2597: cst_department_overheads cdo,
2598: wip_operations wo,
2599: wip_operation_resources wor,
2600: cst_resource_overheads cro
2601: WHERE
2602: w2.wip_entity_id = w1.wip_entity_id AND
2627: (
2628: SELECT 'X'
2629: FROM
2630: cst_department_overheads cdo2,
2631: wip_operations wo2,
2632: cst_resource_overheads cro2,
2633: wip_operation_resources wor2
2634: WHERE
2635: w1.wip_entity_id = wo2.wip_entity_id AND
3824: there are no rows in cst_comp_snapshot table. Resulting which
3825: the calculations based on the CCS table returns zero value.
3826: And value of Assembly returned is incorrect.
3827:
3828: To fix this, have decided to check if the wip_operations table
3829: has any rows for the job(wip_entity_id). If no rows exist then
3830: will use the WRO and WROCD tables to calculate the value else
3831: will use the CCS table to calculate the values.
3832: */
3834: l_routing_check := 0;
3835:
3836: select count(1)
3837: into l_routing_check
3838: from wip_operations wo
3839: where wo.wip_entity_id = i_wip_entity_id;
3840:
3841: if l_routing_check > 0
3842: then