APPS.CST_COST_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 78

        select MP.primary_cost_method,
               MP.default_cost_group_id
        into   l_cost_method_id,
               l_default_cost_group_id
        from   mtl_parameters MP
        where  MP.organization_id = p_organization_id;

Line: 91

                select CIC.item_cost
                into   l_item_cost
                from   cst_item_costs CIC,
                       mtl_parameters mp
                where  CIC.inventory_item_id = p_inventory_item_id     AND
                       CIC.organization_id   = mp.cost_organization_id  AND
                       CIC.cost_type_id      = NVL( p_cost_type_id, 1 ) AND
                       mp.organization_id    = p_organization_id ;

Line: 103

                select CQL.item_cost
                into   l_item_cost
                from   cst_quantity_layers CQL,
                       mtl_parameters mp
                where  CQL.inventory_item_id = p_inventory_item_id    AND
                       CQL.organization_id   = mp.cost_organization_id       AND
                       CQL.cost_group_id     = NVL( p_cost_group_id,
                                                   l_default_cost_group_id ) AND
                       mp.organization_id    = p_organization_id ;