APPS.INL_LANDEDCOST_PUB SQL Statements

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

Line: 48

    SELECT sl.ship_line_id
    FROM inl_ship_lines sl
    WHERE sl.ship_header_id = p_ship_header_id
    AND sl.adjustment_num = 0
    ORDER BY sl.ship_line_id;

Line: 56

    SELECT
        NVL(sl.parent_ship_line_id,sl.ship_line_id) parent_ship_line_id,
        lc.organization_id,
        sl.inventory_item_id,
        sl.primary_qty,
        sl.primary_uom_code,
        lc.component_type,
        SUM(lc.allocated_amt) ALC,
        SUM(lc.estimated_allocated_amt) ELC
    FROM
        inl_ship_lines sl,
        inl_det_landed_costs_v lc
    WHERE lc.ship_header_id   = p_ship_header_id
    AND lc.adjustment_num = (SELECT MAX(alloc.adjustment_num)
                             FROM inl_allocations alloc
                             WHERE alloc.ship_header_id = p_ship_header_id)
    AND sl.ship_line_id     = lc.ship_line_id
    GROUP BY  NVL(sl.parent_ship_line_id,sl.ship_line_id),
        lc.organization_id,
        sl.inventory_item_id,
        sl.primary_qty,
        sl.primary_uom_code,
        lc.component_type
    ORDER BY NVL(sl.parent_ship_line_id,sl.ship_line_id);

Line: 356

    SELECT
        NVL(sl0.parent_ship_line_id,sl0.ship_line_id) parent_ship_line_id,
        lc.organization_id,
        sl0.inventory_item_id,
        sl0.primary_qty,
        sl0.primary_uom_code,
        lc.component_type,
        SUM(lc.allocated_amt) ALC,
        SUM(lc.estimated_allocated_amt) ELC,
        lc.adjustment_num
    FROM
        inl_ship_lines_all sl0,  --access to table (performance)
        inl_det_landed_costs_v lc
    WHERE sl0.ship_line_id  = p_ship_line_id
    AND lc.ship_header_id   = sl0.ship_header_id
    AND lc.adjustment_num = (SELECT MAX(alloc.adjustment_num)
                             FROM inl_allocations alloc
                             WHERE alloc.ship_header_id = sl0.ship_header_id)
    AND lc.ship_line_id = (SELECT MAX(sl.ship_line_id)
                          FROM inl_ship_lines sl --access to synon
                          WHERE sl.ship_header_id     = sl0.ship_header_id
                          AND  sl.ship_line_group_id  = sl0.ship_line_group_id
                          AND sl.ship_line_num        = sl0.ship_line_num
                          AND sl.adjustment_num      <= lc.adjustment_num
                          )
    GROUP BY  NVL(sl0.parent_ship_line_id,sl0.ship_line_id),
        lc.organization_id,
        sl0.inventory_item_id,
        sl0.primary_qty,
        sl0.primary_uom_code,
        lc.component_type,
        lc.adjustment_num
    ;