Select fnd_profile.value('GL_SET_OF_BKS_ID') from dual

select fnd_profile.value('SO_ORGANIZATION_ID') from dual;

select fnd_profile.value('ORG_ID') from dual;

fnd_global.resp_id;

select TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) from dual;
select TO_NUMBER(FND_PROFILE.VALUE('login_ID')) from dual;
org_id = :$PROFILES$.ORG_ID;也可用此来取得,在定义报表参数时来定义;

fnd_profile.value('MFG_ORGANIZATION_ID');

select FND_PROFILE.VALUE('CONCURRENT_REQUEST_ID') from dual;

fnd_global.resp_id;

fnd_global.resp_id;

— 取得当前的库存组织
SELECT t.organization_code
  FROM inv.mtl_parameters t
 WHERE t.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID');
— 取得当前的业务实体
SELECT hou.name
  FROM hr_operating_units hou
 WHERE hou.organization_id = fnd_profile.value('ORG_ID');
 — 取得当前的帐套
SELECT gl.name
  FROM gl_ledgers gl
 WHERE gl.ledger_id = fnd_profile.value('GL_SET_OF_BKS_ID');