DBA Data[Home] [Help]

APPS.CSTPSCCR dependencies on CST_COST_TYPES

Line 52: FROM CST_COST_TYPES

48: +------------------------------------------------------------*/
49:
50: SELECT DEFAULT_COST_TYPE_ID
51: INTO default_cost_type_id
52: FROM CST_COST_TYPES
53: WHERE COST_TYPE_ID = p_dest_cost_type_id;
54:
55: l_stmt_num := 15;
56: -- SCAPI: always do explicit lock

Line 800: FROM CST_COST_TYPES

796: pl_operation_flag,
797: pl_activity_flag,
798: pl_cost_code_flag,
799: pl_element_flag
800: FROM CST_COST_TYPES
801: WHERE COST_TYPE_ID = l_dest_cost_type_id;
802:
803:
804:

Line 2736: FROM CST_COST_TYPES

2732:
2733: /* Supply chain enhancement: default cost type */
2734: SELECT DEFAULT_COST_TYPE_ID
2735: INTO default_cost_type_id
2736: FROM CST_COST_TYPES
2737: WHERE COST_TYPE_ID = l_buy_cost_type_id;
2738:
2739: UPDATE CST_SC_SOURCING_RULES
2740: SET (ITEM_COST,

Line 3162: from cst_cost_types

3158:
3159: sql_stmt_num := 5;
3160: select alternate_bom_designator
3161: into l_snapshot_designator
3162: from cst_cost_types
3163: where cost_type_id = l_cost_type_id;
3164:
3165: if (l_snapshot_designator IS NULL) then
3166: return(return_code);