APPS.CSTPSCCR dependencies on CST_DEPARTMENT_OVERHEADS

Line 1245: cst_department_overheads cdo

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

Line 1351: CST_DEPARTMENT_OVERHEADS cdo,

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

Line 1393: FROM CST_DEPARTMENT_OVERHEADS cdo1

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

Line 1401: FROM CST_DEPARTMENT_OVERHEADS cdo2

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

Line 1485: CST_DEPARTMENT_OVERHEADS cdo,

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

Line 1571: FROM CST_DEPARTMENT_OVERHEADS cdo1

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

Line 1579: FROM CST_DEPARTMENT_OVERHEADS cdo2

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