1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Quer to find concurrent program information base on concurrent program id

Discussion in 'Oracle Apps Technical' started by Bharat, May 16, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Quer to find concurrent program information base on concurrent program id


    Code (Text):
    SELECT r.request_id,
    DECODE (r.description,
    NULL, pt.user_concurrent_program_name,
    r.description || ' ( ' || pt.user_concurrent_program_name
    || ' ) '
    ) program,
    r.phase_code,
    r.status_code,
    fnd_amp_private.get_phase (r.phase_code,
    r.status_code,
    r.hold_flag,
    p.enabled_flag,
    r.requested_start_date,
    r.request_id
    ) phase,
    fnd_amp_private.get_status (r.phase_code,
    r.status_code,
    r.hold_flag,
    p.enabled_flag,
    r.requested_start_date,
    r.request_id
    ) status,
    u.user_name,
    rt.responsibility_name,
    AT.application_name,
    r.requested_start_date,
    r.actual_start_date,
    r.actual_completion_date,
    r.request_date,
    r.argument_text,
    r.oracle_session_id,
    r.completion_text,
    r.controlling_manager,
    r.requested_by,
    r.program_application_id,
    r.concurrent_program_id,
    r.is_sub_request,
    r.parent_request_id,
    r.queue_method_code,
    r.cd_id,
    r.hold_flag,
    p.enabled_flag,
    p.concurrent_program_name,
    p.user_concurrent_program_name,
    r.os_process_id,
    r.nls_language,
    r.nls_territory,
    r.nls_numeric_characters,
    r.description
    FROM fnd_concurrent_programs_tl pt,
    fnd_responsibility_tl rt,
    fnd_application_tl AT,
    fnd_concurrent_programs_vl p,
    fnd_user u,
    fnd_concurrent_requests r
    WHERE r.program_application_id = p.application_id
    AND r.concurrent_program_id = p.concurrent_program_id
    AND pt.concurrent_program_id = p.concurrent_program_id
    AND pt.application_id = p.application_id
    AND pt.LANGUAGE = USERENV ('LANG')
    AND u.user_id = r.requested_by
    AND rt.application_id = r.responsibility_application_id
    AND rt.responsibility_id = r.responsibility_id
    AND rt.LANGUAGE = USERENV ('LANG')
    AND AT.application_id = r.program_application_id
    AND AT.LANGUAGE = USERENV ('LANG')
    AND r.request_id = &request_id;