[Home] [Help]
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
2216: CDO.COST_TYPE_ID = i_res_cost_type_id AND
2391: 1,i_txn_qty,
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
2414: EXISTS
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
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
2487: WO.WIP_ENTITY_ID = i_wip_entity_id AND
2488: WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND
2713: 2,wor.usage_rate_or_amount/l_lot_size),
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
2748: EXISTS
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