APPS.CSTPSCCR dependencies on CST_DEPARTMENT_OVERHEADS

Line 1244: cst_department_overheads cdo

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
1248: cro.cost_type_id = default_cost_type_id

Line 1354: CST_DEPARTMENT_OVERHEADS cdo,

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
1358: AND cia.ORGANIZATION_ID = csllc.organization_id

Line 1396: FROM CST_DEPARTMENT_OVERHEADS cdo1

1392: OR
1393: ( cdo.COST_TYPE_ID = default_cost_type_id
1394: AND NOT EXISTS
1395: (SELECT 'X'
1396: FROM CST_DEPARTMENT_OVERHEADS cdo1
1397: WHERE cdo1.DEPARTMENT_ID = cicd.DEPARTMENT_ID
1398: AND cdo1.COST_TYPE_ID = l_dest_cost_type_id)
1399: )
1400: OR

Line 1404: FROM CST_DEPARTMENT_OVERHEADS cdo2

1400: OR
1401: ( cdo.COST_TYPE_ID = decode(mp.PRIMARY_COST_METHOD, 1, 1, mp.AVG_RATES_COST_TYPE_ID)
1402: AND NOT EXISTS
1403: (SELECT 'X'
1404: FROM CST_DEPARTMENT_OVERHEADS cdo2
1405: WHERE cdo2.DEPARTMENT_ID = cicd.DEPARTMENT_ID
1406: AND cdo2.COST_TYPE_ID in (l_dest_cost_type_id,default_cost_type_id))
1407: )
1408: ); /* Supply chain enhancement: default valuation cost type */

Line 1488: CST_DEPARTMENT_OVERHEADS cdo,

1484: CST_SC_LOW_LEVEL_CODES csllc,
1485: CST_ITEM_COSTS cia,
1486: BOM_OPERATIONAL_ROUTINGS bor,
1487: BOM_OPERATION_SEQUENCES bos,
1488: CST_DEPARTMENT_OVERHEADS cdo,
1489: MTL_PARAMETERS mp
1490: WHERE csllc.ROLLUP_ID = l_rollup_id
1491: AND cia.BASED_ON_ROLLUP_FLAG (+) = 1 /* YES */
1492: AND cia.INVENTORY_ASSET_FLAG (+) = 1

Line 1574: FROM CST_DEPARTMENT_OVERHEADS cdo1

1570: OR
1571: ( cdo.COST_TYPE_ID = default_cost_type_id
1572: AND NOT EXISTS
1573: (SELECT 'X'
1574: FROM CST_DEPARTMENT_OVERHEADS cdo1
1575: WHERE cdo1.DEPARTMENT_ID = cdo.DEPARTMENT_ID
1576: AND cdo1.COST_TYPE_ID = l_dest_cost_type_id)
1577: )
1578: OR

Line 1582: FROM CST_DEPARTMENT_OVERHEADS cdo2

1578: OR
1579: ( cdo.COST_TYPE_ID = decode(mp.PRIMARY_COST_METHOD, 1, 1, mp.AVG_RATES_COST_TYPE_ID)
1580: AND NOT EXISTS
1581: (SELECT 'X'
1582: FROM CST_DEPARTMENT_OVERHEADS cdo2
1583: WHERE cdo2.DEPARTMENT_ID = cdo.DEPARTMENT_ID
1584: AND cdo2.COST_TYPE_ID in (l_dest_cost_type_id,default_cost_type_id))
1585: )
1586: ) /* Supply chain enhancement: default valuation cost type */