FND_PRIFILE.VALUE

USERNAME	Your user's current Oracle Application Object Library username.
USER_ID	Your user's current Oracle Application Object Library user ID.
RESP_ID	Your user's current responsibility ID.
APPL_SHRT_NAME	The short name of the application connected to your user's current responsibility.
RESP_APPL_ID	The application ID of the application connected to your user's current responsibility.
FORM_NAME	The name of the current form. Not available for concurrent programs.
FORM_ID	The form ID of the current form. Not available for concurrent programs.
FORM_APPL_NAME	The name of the application for which the current form is registered. Not available for concurrent programs.
FORM_APPL_ID	The application ID of the application for which the current form is registered. Not available for concurrent programs.
LOGON_DATE	Your user's logon date for the current session.
LAST_LOGON_DATE	Your user's logon date for the previous session.
LOGIN_ID	Your user's Sign–On Audit login ID in Oracle Application Object Library.
CONC_REQUEST_ID	Instance of your running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the REQUEST_ID Who column.
CONC_PROGRAM_ID	The program ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_ID Who column.
CONC_PROGRAM_APPLICATION_ID	The application ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_APPLICATION_ID Who column.
CONC_LOGIN_ID	The login ID associated with a running concurrent program. You can only use this profile option in a concurrent program. You can use this profile option to fill the LAST_UPDATE_LOGIN Who column.
CONC_PRINT_OUTPUT	The value Yes or No that you enter in the Print Output field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program. This profile option determines whether the concurrent managers print the concurrent program's output to the printer.
CONC_PRINT_STYLE	The print style of your concurrent program's output that you enter in the Print Style field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option.
ORG_ID	作業單位  fnd_profile.value('ORG_ID')
MFG_ORGANIZATION_ID	存貨組織  fnd_profile.value(' MFG_ORGANIZATION_ID ')

USERNAME : FND_PROFILE.VALUE('USERNAME')

職責：fnd_profile.value('RESP_NAME')

fnd_profile.value('ORG_ID')