APPS.CSTPSCCR dependencies on CST_RESOURCE_OVERHEADS

Line 1243: FROM cst_resource_overheads cro,

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

Line 1353: CST_RESOURCE_OVERHEADS cro,

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

Line 1371: FROM CST_RESOURCE_OVERHEADS cro1

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

Line 1378: FROM CST_RESOURCE_OVERHEADS cro2

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

Line 1634: CST_RESOURCE_OVERHEADS cro

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