APPS.INL_LANDEDCOST_PUB SQL Statements

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

Line: 99

    SELECT NVL(parent_ship_line_id, ship_line_id)
    INTO l_parent_ship_line_id
    FROM inl_ship_lines
    WHERE ship_line_id = p_ship_line_id;

Line: 104

    SELECT olcv.organization_id,
           olcv.inventory_item_id,
           olcv.primary_qty,
           olcv.primary_uom_code,
           olcv.item_price,
           olcv.charges,
           olcv.taxes,
           olcv.unit_landed_cost
    INTO   x_organization_id,
           x_inventory_item_id,
           x_primary_qty,
           x_primary_uom_code,
           x_estimated_item_price,
           x_estimated_charges,
           x_estimated_taxes,
           x_estimated_unit_landed_cost
    FROM   inl_shipln_landed_costs_v olcv
    WHERE  olcv.ship_line_id = l_parent_ship_line_id
    AND    olcv.adjustment_num = 0;

Line: 132

    SELECT olcv.item_price,
           olcv.charges,
           olcv.taxes,
           olcv.unit_landed_cost
    INTO   x_actual_item_price,
           x_actual_charges,
           x_actual_taxes,
           x_actual_unit_landed_cost
    FROM   inl_shipln_landed_costs_v olcv
    WHERE  olcv.ship_line_id = (SELECT asl.ship_line_id
                                FROM inl_adj_ship_lines_v asl,
                                     inl_ship_lines sl
                                WHERE asl.ship_header_id = sl.ship_header_id
                                AND asl.ship_line_group_id = sl.ship_line_group_id  -- BUG 7702229
                                AND asl.ship_line_num = sl.ship_line_num
                                AND sl.ship_line_id = l_parent_ship_line_id)
    AND    olcv.adjustment_num = (SELECT MAX(adjustment_num)
                                  FROM INL_shipln_landed_costs_v olcv2
                                  WHERE olcv2.ship_line_id = olcv.ship_line_id);