APPS.FND_RT_REQUEST SQL Statements

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

Line: 6

     SELECT FND_RT_REQUESTS_S.nextval into testid FROM DUAL;

Line: 11

    INSERT INTO FND_RT_REQUESTS VALUES (testid, requestid);

Line: 17

    select request_id
    from fnd_concurrent_requests
    where parent_request_id <> -1
    and   parent_request_id is not null
    start with request_id = parent_id
    connect by prior request_id = parent_request_id;

Line: 25

    select request_id
    from   fnd_rt_requests
    where  test_id = testid;

Line: 43

        select count(*) into cnt
        from fnd_concurrent_requests
        where phase_code in ('P', 'R')
        start with request_id = parent.request_id
        connect by prior request_id = parent_request_id;

Line: 53

        INSERT INTO FND_RT_REQUESTS VALUES (testid, child.request_id);

Line: 65

    SELECT REQUEST_ID into reqid
    FROM FND_RT_REQUESTS
    WHERE TEST_ID = testid AND ROWNUM=1;

Line: 69

    DELETE FROM fnd_rt_requests
    WHERE TEST_ID = testid
    AND REQUEST_ID = reqid;