[Home] [Help]
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
2142: CDO.COST_TYPE_ID = i_res_cost_type_id AND
2299: 1,i_txn_qty,
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
2322: EXISTS
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
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
2395: WO.WIP_ENTITY_ID = i_wip_entity_id AND
2396: WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND
2593: 2,wor.usage_rate_or_amount/l_lot_size),
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
2626: EXISTS
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