[Home] [Help]
990: BOM_OPERATIONAL_ROUTINGS bor,
991: BOM_OPERATION_SEQUENCES bos,
992: BOM_OPERATION_RESOURCES bomres,
993: BOM_RESOURCES br,
994: CST_RESOURCE_COSTS crc
995: WHERE csllc.ROLLUP_ID = l_rollup_id
996: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
997: AND cia.ORGANIZATION_ID = csllc.organization_id
998: AND cia.COST_TYPE_ID = l_dest_cost_type_id
1074: crc.COST_TYPE_ID = l_dest_cost_type_id
1075: OR
1076: ( crc.COST_TYPE_ID = default_cost_type_id
1077: AND NOT EXISTS (SELECT 'X'
1078: FROM CST_RESOURCE_COSTS crc1
1079: WHERE crc1.RESOURCE_ID = bomres.RESOURCE_ID
1080: AND crc1.COST_TYPE_ID = l_dest_cost_type_id)
1081: )
1082: OR
1081: )
1082: OR
1083: ( crc.COST_TYPE_ID = decode(mp.PRIMARY_COST_METHOD, 1, 1, mp.AVG_RATES_COST_TYPE_ID)
1084: AND NOT EXISTS (SELECT 'X'
1085: FROM CST_RESOURCE_COSTS crc2
1086: WHERE crc2.RESOURCE_ID = bomres.RESOURCE_ID
1087: AND crc2.COST_TYPE_ID in (l_dest_cost_type_id,default_cost_type_id))
1088: )
1089: ) /* Supply chain enhancement: default valuation cost type */
1093:
1094: --======================================================================================
1095: -- Added the following Insert Statement as part of fix for Bug# 3967455 (foreport bug 4032733,4283663)
1096:
1097: -- to Insert records into CICD for which Resource rates are not defined (in CST_RESOURCE_COSTS)
1098: -- but have OverHeads defined with Basis Type = 3 (i.e. Resource Unit based) only
1099: -- since for such Basis Type, the user need not assign any Resource Rate.
1100: -- This is added as a separate statement so as to avoid using OUTER Joins in the above Insert
1101: -- Statement (sql_stmt_num 60).
1228: AND br.ALLOW_COSTS_FLAG = 1
1229:
1230: -- To Exclude resource records that have rates defined
1231: AND NOT EXISTS (SELECT 'resource rate defined'
1232: FROM cst_resource_costs crc
1233: WHERE crc.resource_id = bomres.resource_id
1234: AND (crc.cost_type_id = l_dest_cost_type_id
1235: OR
1236: crc.COST_TYPE_ID = default_cost_type_id