ebs常用脚本及相关fnd表

DECLARE
  -- CONSTANT VALUES DEFINE
  lcn_user_id                        CONSTANT NUMBER := 1298;
  lcn_resp_id                        CONSTANT NUMBER := 2056;
  lcn_resp_appl_id               CONSTANT NUMBER := 706;
  lcn_security_group_id       CONSTANT NUMBER := 0;
  lcn_site_id                          CONSTANT NUMBER := 0;
  lcn_prog_appl_id               CONSTANT NUMBER := 20008;
  lcn_conc_program_id         CONSTANT NUMBER := 64332;
  lcn_conc_request_id           CONSTANT NUMBER := 123456;
  lcn_conc_priority_request CONSTANT NUMBER := 0;
  --
  -- VARIABLE VALUES DEFINE
  lvn_session_id NUMBER;
--
BEGIN
  fnd_global.initialize(
    session_id                 => lvn_session_id,
    user_id                      => lcn_user_id,
    resp_id                      => lcn_resp_id,
    resp_appl_id             => lcn_resp_appl_id,
    security_group_id     => lcn_security_group_id,
    site_id                        => lcn_site_id,
    login_id                      => lcn_user_id,
    conc_login_id            => lcn_user_id,
    prog_appl_id             => lcn_prog_appl_id,
    conc_program_id       => lcn_conc_program_id,
    conc_request_id          => lcn_conc_request_id,
    conc_priority_request => lcn_conc_priority_request);
  dbms_output.put_line(to_char(lvn_session_id));
END;

------------------------------------------------------
-- user direct resp group
SELECT furgd.*
FROM fnd_user_resp_groups_direct furgd
WHERE furgd.user_id = 1298
AND   furgd.RESPONSIBILITY_ID = 20560
--
-- query one resp information
SELECT frt.responsibility_name,fr.*
FROM fnd_responsibility fr,
     fnd_responsibility_tl frt
WHERE fr.responsibility_id = frt.responsibility_id
AND frt.responsibility_name = '仕掛'
--
-- other ways to query
SELECT furg.user_id,
       furg.RESPONSIBILITY_ID,
       furg.RESPONSIBILITY_APPLICATION_ID
FROM fnd_user_resp_groups furg
WHERE furg.user_id = 1298
AND furg.RESPONSIBILITY_ID = 20560
--
-- query concurrent program information
SELECT fc.*
FROM fnd_concurrent_programs fc
WHERE fc.concurrent_program_name LIKE 'XXWIP_016_IF002%'
------------------------------------------------------