[Home] [Help]
1025: SYSDATE,
1026: SYSDATE
1027: FROM
1028: WIP_OPERATIONS WO,
1029: CST_DEPARTMENT_OVERHEADS CDO
1030: WHERE
1031: WO.WIP_ENTITY_ID = i_wip_entity_id AND
1032: WO.DEPARTMENT_ID = CDO.DEPARTMENT_ID AND
1033: CDO.COST_TYPE_ID = i_res_cost_type_id AND
1190: 1,i_txn_qty,
1191: 2,i_txn_qty/i_lot_size)))
1192: FROM
1193: wip_operation_overheads w2,
1194: cst_department_overheads cdo,
1195: wip_operations wo
1196: WHERE
1197: w2.wip_entity_id = w1.wip_entity_id AND
1198: w2.organization_id = w1.organization_id AND
1216: EXISTS
1217: (
1218: SELECT 'X'
1219: FROM
1220: cst_department_overheads cdo2,
1221: wip_operations wo2
1222: WHERE
1223: wo2.wip_entity_id = w1.wip_entity_id AND
1224: wo2.organization_id = w1.organization_id AND
1384: NOT EXISTS
1385: (
1386: SELECT 'X'
1387: FROM
1388: CST_DEPARTMENT_OVERHEADS CDO2,
1389: WIP_OPERATIONS WO2
1390: WHERE
1391: WO2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1392: WO2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1451: SYSDATE
1452: FROM
1453: WIP_OPERATIONS WO,
1454: WIP_OPERATION_RESOURCES WOR,
1455: CST_DEPARTMENT_OVERHEADS CDO,
1456: CST_RESOURCE_OVERHEADS CRO
1457: WHERE
1458: WO.WIP_ENTITY_ID = i_wip_entity_id AND
1459: WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND
1657: 2,wor.usage_rate_or_amount/i_lot_size),
1658: 4,nvl(wor.temp_relieved_value,0))))
1659: FROM
1660: wip_operation_overheads w2,
1661: cst_department_overheads cdo,
1662: wip_operations wo,
1663: wip_operation_resources wor,
1664: cst_resource_overheads cro
1665: WHERE
1691: EXISTS
1692: (
1693: SELECT 'X'
1694: FROM
1695: cst_department_overheads cdo2,
1696: wip_operations wo2,
1697: cst_resource_overheads cro2,
1698: wip_operation_resources wor2
1699: WHERE
1869: NOT EXISTS
1870: (
1871: SELECT 'X'
1872: FROM
1873: CST_DEPARTMENT_OVERHEADS CDO2,
1874: WIP_OPERATIONS WO2,
1875: CST_RESOURCE_OVERHEADS CRO2,
1876: WIP_OPERATION_RESOURCES WOR2
1877: WHERE