SELECT USER_ID,
RESPONSIBILITY_ID,
RESPONSIBILITY_APPLICATION_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID =
(SELECT USER_ID FROM FND_USER WHERE USER_NAME = '&user_name')
AND RESPONSIBILITY_ID =
(SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = '&resp_name'
);
-- Jeżeli chcemy dynamicznie pobrać idki w zleceniu współbieżnym
FND_GLOBAL.USER_ID
FND_GLOBAL.RESP_ID
FND_GLOBAL.RESP_APPL_ID
--poniższe wywołanie zlecenie samo wywołuje
FND_GLOBAL.Apps_Initialize(FND_GLOBAL.USER_ID,FND_GLOBAL.RESP_ID,FND_GLOBAL.RESP_APPL_ID);
--wykonanie
PROMPT Initialize context OF profiles, etc.
PROMPT Note you can query the USER id, responsibility id,
PROMPT AND application id FROM the FND tables.
EXECUTE fnd_global.APPS_INITIALIZE(UserID,ResponsibilityID,ApplicationID); |
SELECT USER_ID,
RESPONSIBILITY_ID,
RESPONSIBILITY_APPLICATION_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID =
(SELECT USER_ID FROM FND_USER WHERE USER_NAME = '&user_name')
AND RESPONSIBILITY_ID =
(SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = '&resp_name'
);
-- Jeżeli chcemy dynamicznie pobrać idki w zleceniu współbieżnym
FND_GLOBAL.USER_ID
FND_GLOBAL.RESP_ID
FND_GLOBAL.RESP_APPL_ID
--poniższe wywołanie zlecenie samo wywołuje
FND_GLOBAL.Apps_Initialize(FND_GLOBAL.USER_ID,FND_GLOBAL.RESP_ID,FND_GLOBAL.RESP_APPL_ID);
--wykonanie
PROMPT Initialize context of profiles, etc.
PROMPT Note you can query the user id, responsibility id,
PROMPT and application id from the FND tables.
execute fnd_global.APPS_INITIALIZE(UserID,ResponsibilityID,ApplicationID);
Ten wpis został opublikowany w kategorii
_EBS - ogólnie,
PLSQL,
SQL-ki. Dodaj zakładkę do
bezpośredniego odnośnika.