APPS.WSH_OE_CONSTRAINTS SQL Statements

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

Line: 22

    SELECT released_status
    FROM   wsh_delivery_details
    WHERE  source_code = 'OE'
    AND    source_line_id = x_line_id
    AND    released_status IN ('S', 'Y', 'X')
    AND    rownum = 1;

Line: 31

    SELECT staged_flag
    FROM   mtl_reservations
    WHERE  demand_source_line_id = x_line_id;

Line: 216

    SELECT released_status
    FROM   wsh_delivery_details
    WHERE  source_code = 'OE'
    AND    source_line_id = x_line_id
    AND    released_status IN ('S', 'Y', 'C')
    AND    rownum = 1;