{"id":859,"date":"2016-08-03T16:16:19","date_gmt":"2016-08-03T08:16:19","guid":{"rendered":"http:\/\/www.oracle.name\/?p=859"},"modified":"2016-08-03T16:19:28","modified_gmt":"2016-08-03T08:19:28","slug":"ebs%e5%b8%b8%e7%94%a8%e7%9a%84%e9%85%8d%e7%bd%ae%e5%8f%82%e6%95%b0%e8%8e%b7%e5%8f%96","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=859","title":{"rendered":"EBS\u5e38\u7528\u7684\u914d\u7f6e\u53c2\u6570\u83b7\u53d6"},"content":{"rendered":"

\n\t Select fnd_profile.value('GL_SET_OF_BKS_ID') from dual\n<\/p>\n

\n\tselect fnd_profile.value('SO_ORGANIZATION_ID') from dual;\n<\/p>\n

\n\tselect fnd_profile.value('ORG_ID') from dual;\n<\/p>\n

\n\tfnd_global.resp_id;\n<\/p>\n

\n\tselect TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) from dual;
\n\tselect TO_NUMBER(FND_PROFILE.VALUE('login_ID')) from dual;
\n\torg_id = :$PROFILES$.ORG_ID;\u4e5f\u53ef\u7528\u6b64\u6765\u53d6\u5f97,\u5728\u5b9a\u4e49\u62a5\u8868\u53c2\u6570\u65f6\u6765\u5b9a\u4e49;\n<\/p>\n

\n\tfnd_profile.value('MFG_ORGANIZATION_ID');\n<\/p>\n

\n\tselect FND_PROFILE.VALUE('CONCURRENT_REQUEST_ID') from dual;\n<\/p>\n

\n\tfnd_global.resp_id;\n<\/p>\n

\n\t— \u53d6\u5f97\u5f53\u524d\u7684\u5e93\u5b58\u7ec4\u7ec7
\n\tSELECT t.organization_code
\n\t FROM inv.mtl_parameters t
\n\t WHERE t.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID');
\n\t— \u53d6\u5f97\u5f53\u524d\u7684\u4e1a\u52a1\u5b9e\u4f53
\n\tSELECT hou.name
\n\t FROM hr_operating_units hou
\n\t WHERE hou.organization_id = fnd_profile.value('ORG_ID');
\n\t — \u53d6\u5f97\u5f53\u524d\u7684\u5e10\u5957
\n\tSELECT gl.name
\n\t FROM gl_ledgers gl
\n\t WHERE gl.ledger_id = fnd_profile.value('GL_SET_OF_BKS_ID');<\/p>\n","protected":false},"excerpt":{"rendered":"