[Home] [Help]
1107: SYSDATE,
1108: SYSDATE
1109: FROM
1110: WIP_OPERATIONS WO,
1111: CST_DEPARTMENT_OVERHEADS CDO
1112: WHERE
1113: WO.WIP_ENTITY_ID = i_wip_entity_id AND
1114: WO.DEPARTMENT_ID = CDO.DEPARTMENT_ID AND
1115: CDO.COST_TYPE_ID = i_res_cost_type_id AND
1294: 1,i_txn_qty,
1295: 2,i_txn_qty/i_lot_size)))
1296: FROM
1297: wip_operation_overheads w2,
1298: cst_department_overheads cdo,
1299: wip_operations wo
1300: WHERE
1301: w2.wip_entity_id = w1.wip_entity_id AND
1302: w2.organization_id = w1.organization_id AND
1320: EXISTS
1321: (
1322: SELECT 'X'
1323: FROM
1324: cst_department_overheads cdo2,
1325: wip_operations wo2
1326: WHERE
1327: wo2.wip_entity_id = w1.wip_entity_id AND
1328: wo2.organization_id = w1.organization_id AND
1506: NOT EXISTS
1507: (
1508: SELECT 'X'
1509: FROM
1510: CST_DEPARTMENT_OVERHEADS CDO2,
1511: WIP_OPERATIONS WO2
1512: WHERE
1513: WO2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1514: WO2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1573: SYSDATE
1574: FROM
1575: WIP_OPERATIONS WO,
1576: WIP_OPERATION_RESOURCES WOR,
1577: CST_DEPARTMENT_OVERHEADS CDO,
1578: CST_RESOURCE_OVERHEADS CRO
1579: WHERE
1580: WO.WIP_ENTITY_ID = i_wip_entity_id AND
1581: WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND
1809: 2,wor.usage_rate_or_amount/i_lot_size),
1810: 4,nvl(wor.temp_relieved_value,0))))
1811: FROM
1812: wip_operation_overheads w2,
1813: cst_department_overheads cdo,
1814: wip_operations wo,
1815: wip_operation_resources wor,
1816: cst_resource_overheads cro
1817: WHERE
1845: EXISTS
1846: (
1847: SELECT 'X'
1848: FROM
1849: cst_department_overheads cdo2,
1850: wip_operations wo2,
1851: cst_resource_overheads cro2,
1852: wip_operation_resources wor2
1853: WHERE
2023: NOT EXISTS
2024: (
2025: SELECT 'X'
2026: FROM
2027: CST_DEPARTMENT_OVERHEADS CDO2,
2028: WIP_OPERATIONS WO2,
2029: CST_RESOURCE_OVERHEADS CRO2,
2030: WIP_OPERATION_RESOURCES WOR2
2031: WHERE