[Home] [Help]
2207: -1,
2208: SYSDATE,
2209: SYSDATE
2210: FROM
2211: WIP_OPERATIONS WO,
2212: CST_DEPARTMENT_OVERHEADS CDO
2213: WHERE
2214: WO.WIP_ENTITY_ID = i_wip_entity_id AND
2215: WO.DEPARTMENT_ID = CDO.DEPARTMENT_ID AND
2392: 2,i_txn_qty/l_lot_size)))
2393: FROM
2394: wip_operation_overheads w2,
2395: cst_department_overheads cdo,
2396: wip_operations wo
2397: WHERE
2398: w2.wip_entity_id = w1.wip_entity_id AND
2399: w2.organization_id = w1.organization_id AND
2400: w2.operation_seq_num = w1.operation_seq_num AND
2415: (
2416: SELECT 'X'
2417: FROM
2418: cst_department_overheads cdo2,
2419: wip_operations wo2
2420: WHERE
2421: wo2.wip_entity_id = w1.wip_entity_id AND
2422: wo2.organization_id = w1.organization_id AND
2423: wo2.operation_seq_num = w1.operation_seq_num AND
2478: -1,
2479: SYSDATE,
2480: SYSDATE
2481: FROM
2482: WIP_OPERATIONS WO,
2483: WIP_OPERATION_RESOURCES WOR,
2484: CST_DEPARTMENT_OVERHEADS CDO,
2485: CST_RESOURCE_OVERHEADS CRO
2486: WHERE
2714: 4,nvl(wor.temp_relieved_value,0))))
2715: FROM
2716: wip_operation_overheads w2,
2717: cst_department_overheads cdo,
2718: wip_operations wo,
2719: wip_operation_resources wor,
2720: cst_resource_overheads cro
2721: WHERE
2722: w2.wip_entity_id = w1.wip_entity_id AND
2749: (
2750: SELECT 'X'
2751: FROM
2752: cst_department_overheads cdo2,
2753: wip_operations wo2,
2754: cst_resource_overheads cro2,
2755: wip_operation_resources wor2
2756: WHERE
2757: w1.wip_entity_id = wo2.wip_entity_id AND
3989: there are no rows in cst_comp_snapshot table. Resulting which
3990: the calculations based on the CCS table returns zero value.
3991: And value of Assembly returned is incorrect.
3992:
3993: To fix this, have decided to check if the wip_operations table
3994: has any rows for the job(wip_entity_id). If no rows exist then
3995: will use the WRO and WROCD tables to calculate the value else
3996: will use the CCS table to calculate the values.
3997: */
3999: l_routing_check := 0;
4000:
4001: select count(1)
4002: into l_routing_check
4003: from wip_operations wo
4004: where wo.wip_entity_id = i_wip_entity_id;
4005:
4006: if l_routing_check > 0
4007: then