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