APPS.CSTPSCCR dependencies on CST_RESOURCE_OVERHEADS

Line 1244: FROM cst_resource_overheads cro,

1240: )
1241: )
1242: -- To get Overhead records of Basis Type = 3 (i.e Resource Unit based OH) only
1243: AND EXISTS (SELECT 'overhead exists for resource rate not defined'
1244: FROM cst_resource_overheads cro,
1245: cst_department_overheads cdo
1246: WHERE cro.resource_id = bomres.resource_id
1247: AND (cro.cost_type_id = l_dest_cost_type_id
1248: OR

Line 1350: CST_RESOURCE_OVERHEADS cro,

1346: FROM
1347: CST_SC_LOW_LEVEL_CODES csllc,
1348: CST_ITEM_COSTS cia,
1349: CST_ITEM_COST_DETAILS cicd,
1350: CST_RESOURCE_OVERHEADS cro,
1351: CST_DEPARTMENT_OVERHEADS cdo,
1352: MTL_PARAMETERS mp
1353: WHERE csllc.ROLLUP_ID = l_rollup_id
1354: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID

Line 1368: FROM CST_RESOURCE_OVERHEADS cro1

1364: cro.COST_TYPE_ID = l_dest_cost_type_id
1365: OR
1366: ( cro.COST_TYPE_ID = default_cost_type_id
1367: AND NOT EXISTS (SELECT 'X'
1368: FROM CST_RESOURCE_OVERHEADS cro1
1369: WHERE cro1.RESOURCE_ID = cicd.RESOURCE_ID
1370: AND cro1.COST_TYPE_ID = l_dest_cost_type_id)
1371: )
1372: OR

Line 1375: FROM CST_RESOURCE_OVERHEADS cro2

1371: )
1372: OR
1373: ( cro.COST_TYPE_ID = decode(mp.PRIMARY_COST_METHOD, 1, 1, mp.AVG_RATES_COST_TYPE_ID)
1374: AND NOT EXISTS (SELECT 'X'
1375: FROM CST_RESOURCE_OVERHEADS cro2
1376: WHERE cro2.RESOURCE_ID = cicd.RESOURCE_ID
1377: AND cro2.COST_TYPE_ID in (l_dest_cost_type_id,default_cost_type_id))
1378: )
1379: ) /* Supply chain enhancement: default valuation cost type */

Line 1631: CST_RESOURCE_OVERHEADS cro

1627: 4,ROUND(cicd.USAGE_RATE_OR_AMOUNT*
1628: NVL(SUM(cicd1.ITEM_COST),0),l_ext_tbl(i)))
1629: FROM
1630: CST_ITEM_COST_DETAILS cicd1,
1631: CST_RESOURCE_OVERHEADS cro
1632: WHERE cicd1.INVENTORY_ITEM_ID = cicd.INVENTORY_ITEM_ID
1633: AND cicd1.ORGANIZATION_ID = l_org_id_tbl(i)
1634: AND cicd1.COST_TYPE_ID = l_dest_cost_type_id
1635: AND cicd1.RESOURCE_ID = cro.RESOURCE_ID