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 2737: FROM CST_COST_TYPES

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

Line 3163: from cst_cost_types

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