DBA Data[Home] [Help]

APPS.CST_COST_API dependencies on MTL_PARAMETERS

Line 82: from mtl_parameters MP

78: select MP.primary_cost_method,
79: MP.default_cost_group_id
80: into l_cost_method_id,
81: l_default_cost_group_id
82: from mtl_parameters MP
83: where MP.organization_id = p_organization_id;
84:
85: -- Changes introduced in if statement to select the item cost from the
86: -- Cost Organization please refer to bug 6431253 for further

Line 94: mtl_parameters mp

90: l_stmt_num := 20;
91: select CIC.item_cost
92: into l_item_cost
93: from cst_item_costs CIC,
94: mtl_parameters mp
95: where CIC.inventory_item_id = p_inventory_item_id AND
96: CIC.organization_id = mp.cost_organization_id AND
97: CIC.cost_type_id = NVL( p_cost_type_id, 1 ) AND
98: mp.organization_id = p_organization_id ;

Line 106: mtl_parameters mp

102: l_stmt_num := 30;
103: select CQL.item_cost
104: into l_item_cost
105: from cst_quantity_layers CQL,
106: mtl_parameters mp
107: where CQL.inventory_item_id = p_inventory_item_id AND
108: CQL.organization_id = mp.cost_organization_id AND
109: CQL.cost_group_id = NVL( p_cost_group_id,
110: l_default_cost_group_id ) AND