Oracle Fusion Cloud HCM Tables and Views for HCM

https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/
Admin
This documentation provides a comprehensive reference for the database tables and views used across...
Tokens:1,442,545
Snippets:2,469
Trust Score:9.7
Update:1 year ago
Show doc for...
Tokens:
Raw
### IRC_CX_SITE_THEME_LINKS_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/irccxsitethemelinksvl-4047

An example SQL query to retrieve data from the IRC_CX_SITE_THEME_LINKS_VL view.

```APIDOC
## Query for IRC_CX_SITE_THEME_LINKS_VL

### Description
This section provides an example SQL statement to query the IRC_CX_SITE_THEME_LINKS_VL view, joining with the transactional table to get localized link information.

### SQL Statement
```sql
SELECT 
    IRC_CX_SITE_THEME_LINKS_B.LINK_ID, 
    IRC_CX_SITE_THEME_LINKS_B.OBJECT_STATUS, 
    IRC_CX_SITE_THEME_LINKS_B.OBJECT_VERSION_NUMBER, 
    IRC_CX_SITE_THEME_LINKS_B.LINK_NUMBER, 
    IRC_CX_SITE_THEME_LINKS_B.PARENT_LINK_NUMBER, 
    IRC_CX_SITE_THEME_LINKS_B.VISIBLE_ON_MOBILE, 
    IRC_CX_SITE_THEME_LINKS_B.LINK_TYPE, 
    IRC_CX_SITE_THEME_LINKS_B.LINK_ORDER, 
    IRC_CX_SITE_THEME_LINKS_TL.LINK_NAME, 
    IRC_CX_SITE_THEME_LINKS_B.THEME_ID, 
    IRC_CX_SITE_THEME_LINKS_B.CREATED_BY, 
    IRC_CX_SITE_THEME_LINKS_B.CREATION_DATE, 
    IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATED_BY, 
    IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATE_DATE, 
    IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATE_LOGIN, 
    IRC_CX_SITE_THEME_LINKS_TL.LINK_URL, 
    IRC_CX_SITE_THEME_LINKS_TL.LINK_TEXT 
FROM 
    IRC_CX_SITE_THEME_LINKS_B, 
    IRC_CX_SITE_THEME_LINKS_TL 
WHERE 
    IRC_CX_SITE_THEME_LINKS_B.LINK_ID = IRC_CX_SITE_THEME_LINKS_TL.LINK_ID 
    AND IRC_CX_SITE_THEME_LINKS_TL.LANGUAGE = USERENV('LANG')
```
```

--------------------------------

### PER_REQUISITIONS_INTERFACE_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/perrequisitionsinterfacevl-4241

An example SQL query to retrieve data from the PER_REQUISITIONS_INTERFACE_VL view.

```APIDOC
## PER_REQUISITIONS_INTERFACE_VL Query

### Description
Example SQL statement for querying the PER_REQUISITIONS_INTERFACE_VL view.

### SQL Statement
```sql
SELECT B.REQUISITION_INTERFACE_ID REQUISITION_INTERFACE_ID, B.REQUISITION_INTERFACE_CODE REQUISITION_INTERFACE_CODE, B.ENTERPRISE_ID ENTERPRISE_ID, TL.REQUISITION_TITLE REQUISITION_TITLE, B.INTERFACE_TYPE INTERFACE_TYPE, B.INTERFACE_SOURCE INTERFACE_SOURCE, B.INTERFACE_SOURCE_ID INTERFACE_SOURCE_ID, B.VACANCY_STATUS VACANCY_STATUS, B.REQUISITION_NUMBER REQUISITION_NUMBER, B.REQUISITION_STATUS REQUISITION_STATUS, B.REQUISITION_JUSTIFICATION REQUISITION_JUSTIFICATION, B.REQUISITION_TEMPLATE_CODE REQUISITION_TEMPLATE_CODE, B.TARGET_START_DATE TARGET_START_DATE, B.JOB_SCHEDULE JOB_SCHEDULE, B.TOTAL_OPEN_HEADCOUNT TOTAL_OPEN_HEADCOUNT, B.TOTAL_HIRED_HEADCOUNT TOTAL_HIRED_HEADCOUNT, B.TOTAL_AVAILABLE_HEADCOUNT TOTAL_AVAILABLE_HEADCOUNT, B.MANAGER_USER_NAME MANAGER_USER_NAME, B.MANAGER_ID MANAGER_ID, B.MANAGER_ASSIGNMENT_ID MANAGER_ASSIGNMENT_ID, B.MANAGER_TYPE MANAGER_TYPE, B.JOB_ID JOB_ID, B.ORGANIZATION_ID ORGANIZATION_ID, B.PRIMARY_LOCATION_ID PRIMARY_LOCATION_ID, B.POSITION_ID POSITION_ID, B.EMPLOYEE_STATUS EMPLOYEE_STATUS, B.UNLIMITED_HIRE UNLIMITED_HIRE, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY LAST_UPDATED_BY FROM PER_REQUISITIONS_INTERFACE_B B, PER_REQUISITIONS_INTERFACE_TL TL WHERE B.REQUISITION_INTERFACE_ID = TL.REQUISITION_INTERFACE_ID AND TL.LANGUAGE = USERENV('LANG')
```
```

--------------------------------

### HRT_PERSONS_X Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtpersonsx-3095

An example SQL statement demonstrating how to query the HRT_PERSONS_X view and related tables.

```APIDOC
## HRT_PERSONS_X Query Example

### Description
This section provides an example SQL query to retrieve comprehensive person details by joining HRT_PERSONS_X with other relevant HR schema views.

### SQL Statement
```sql
SELECT 
    person.PERSON_ID, 
    person.DATE_OF_BIRTH, 
    person.DATE_OF_DEATH, 
    person.COUNTRY_OF_BIRTH, 
    person.REGION_OF_BIRTH, 
    person.TOWN_OF_BIRTH, 
    personname.TITLE, 
    personname.FULL_NAME, 
    personname.FIRST_NAME, 
    personname.LAST_NAME, 
    personname.MIDDLE_NAMES, 
    personaddress.ADDRESS_LINE_1, 
    personaddress.ADDRESS_LINE_2, 
    personaddress.ADDRESS_LINE_3, 
    personaddress.COUNTRY, 
    personaddress.POSTAL_CODE, 
    personaddress.REGION_1, 
    personaddress.REGION_2, 
    personaddress.REGION_3, 
    personaddress.TOWN_OR_CITY, 
    personemail.EMAIL_ADDRESS, 
    personphone.PHONE_NUMBER, 
    personphone.EXTENSION 
FROM 
    PER_PERSONS_X person, 
    PER_ALL_PEOPLE_F_V people, 
    PER_PERSON_NAMES_F_V personname, 
    PER_ADDRESSES_F personaddress, 
    PER_EMAIL_ADDRESSES_V personemail, 
    PER_PHONES_V personphone 
WHERE 
    ((person.PERSON_ID = people.PERSON_ID) AND (TRUNC(SYSDATE) BETWEEN people.EFFECTIVE_START_DATE AND people.EFFECTIVE_END_DATE) )
    AND ((person.PERSON_ID = personname.PERSON_ID) AND (TRUNC(SYSDATE) BETWEEN personname.EFFECTIVE_START_DATE AND personname.EFFECTIVE_END_DATE) )
    AND ((personaddress.ADDRESS_ID(+) = people.MAILING_ADDRESS_ID) AND (TRUNC(SYSDATE) BETWEEN personaddress.EFFECTIVE_START_DATE(+) AND personaddress.EFFECTIVE_END_DATE(+)) )
    AND ((personemail.EMAIL_ADDRESS_ID(+) = people.PRIMARY_EMAIL_ID) )
    AND ((personphone.PHONE_ID(+) = people.PRIMARY_PHONE_ID) )
```

--------------------------------

### PAY_TMPLT_CLMN_INST_TRANS_F_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/paytmpltclmninsttransfvl-3338

An example SQL query to retrieve data from the PAY_TMPLT_CLMN_INST_TRANS_F_VL view, joining with the translation table to get language-specific values.

```APIDOC
## Query for PAY_TMPLT_CLMN_INST_TRANS_F_VL

### Description
This SQL statement retrieves column instance details and their translated values for the current user's language.

### Method
SELECT

### Endpoint
N/A (SQL Query)

### Query
```sql
SELECT 
    PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID CLMN_INST_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,
    PAY_TMPLT_CLMN_INST_TRANS_F.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,
    PAY_TMPLT_CLMN_INST_TRANS_F.COL_ID COL_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.BASE_CLMN_INST_ID BASE_CLMN_INST_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.BASE_COL_VALUE BASE_COL_VALUE,
    PAY_TMPLT_CLMN_INST_TRANS_F.ROW_INST_ID ROW_INST_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F_TL.COL_VALUE COL_VALUE,
    PAY_TMPLT_CLMN_INST_TRANS_F.COL_CLOB_VALUE COL_CLOB_VALUE,
    PAY_TMPLT_CLMN_INST_TRANS_F.SURROGATE_KEY_VALUE SURROGATE_KEY_VALUE,
    PAY_TMPLT_CLMN_INST_TRANS_F.RENAME_FLAG RENAME_FLAG,
    PAY_TMPLT_CLMN_INST_TRANS_F.RULE_ID RULE_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.USE_EXISTING_REC USE_EXISTING_REC,
    PAY_TMPLT_CLMN_INST_TRANS_F.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,
    PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.LEGISLATION_CODE LEGISLATION_CODE,
    PAY_TMPLT_CLMN_INST_TRANS_F.ENTERPRISE_ID ENTERPRISE_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.MODULE_ID MODULE_ID,
    PAY_TMPLT_CLMN_INST_TRANS_F.CREATED_BY CREATED_BY,
    PAY_TMPLT_CLMN_INST_TRANS_F.CREATION_DATE CREATION_DATE,
    PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATED_BY LAST_UPDATED_BY,
    PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_DATE LAST_UPDATE_DATE,
    PAY_TMPLT_CLMN_INST_TRANS_F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,
    PAY_TMPLT_CLMN_INST_TRANS_F.SGUID SGUID 
FROM 
    PAY_TMPLT_CLMN_INST_TRANS_F, PAY_TMPLT_CLMN_INST_TRANS_F_TL 
WHERE 
    PAY_TMPLT_CLMN_INST_TRANS_F.CLMN_INST_ID = PAY_TMPLT_CLMN_INST_TRANS_F_TL.CLMN_INST_ID 
    AND PAY_TMPLT_CLMN_INST_TRANS_F_TL.LANGUAGE = USERENV('LANG')
```
```

--------------------------------

### HRT_CHANNEL_SETUP_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtchannelsetupvl-3456

Provides a sample SQL query to retrieve data from the HRT_CHANNEL_SETUP_VL view.

```APIDOC
## View HRT_CHANNEL_SETUP_VL Query Example

### Description
This section provides a sample SQL query to fetch channel setup details, including translated names and descriptions.

### Method
GET

### Endpoint
/websites/oracle_en_cloud_saas_human-resources_oedmh/tables-and-views/HRT_CHANNEL_SETUP_VL/query

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
None

### Response
#### Success Response (200)
- **SQL_Statement** (string) - The SQL query used to retrieve data from the view.

#### Response Example
```sql
SELECT B.CHANNEL_ID, B.BUSINESS_GROUP_ID, B.EMAIL_ID, B.CODE, B.TYPE, B.DEPENDENT_CHANNEL_ID, B.ENABLED, B.PAGENAME, B.INCOMING_SERVER_PROTOCOL, B.INCOMING_SERVER_HOST, B.INCOMING_SERVER_PORT, B.INCOMING_SERVER_AUTH_TYPE, B.INCOMING_SERVER_AUTH_KEY, B.INCOMING_SERVER_AUTH_VALUE, B.INCOMING_SERVER_BEARER_TOKEN, B.INCOMING_SERVER_SSL, B.OUTGOING_SERVER_PROTOCOL, B.OUTGOING_SERVER_HOST, B.OUTGOING_SERVER_PORT, B.OUTGOING_SERVER_AUTH_TYPE, B.OUTGOING_SERVER_AUTH_KEY, B.OUTGOING_SERVER_AUTH_VALUE, B.OUTGOING_SERVER_BEARER_TOKEN, B.RECEIVE_FOLDER, TL.NAME, TL.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HRT_CHANNEL_SETUP_B B, HRT_CHANNEL_SETUP_TL TL WHERE B.CHANNEL_ID = TL.CHANNEL_ID AND B.BUSINESS_GROUP_ID = TL.BUSINESS_GROUP_ID AND TL.LANGUAGE = USERENV('LANG')
```
```

--------------------------------

### HRT_CHANNEL_SETUP_B Table Documentation

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtchannelsetupb-6830

Documentation for the HRT_CHANNEL_SETUP_B table, detailing its structure, columns, and constraints.

```APIDOC
## HRT_CHANNEL_SETUP_B Table

### Description
The table stores the channel definition.

### Details
- **Schema**: FUSION
- **Object owner**: HRT
- **Object type**: TABLE
- **Tablespace**: Default

### Primary Key
- **Name**: HRT_CHANNEL_SETUP_B_PK
- **Columns**: CHANNEL_ID, BUSINESS_GROUP_ID

### Columns
| Name                  | Datatype   | Length | Precision | Not-null | Comments                                                                                      |
|-----------------------|------------|--------|-----------|----------|-----------------------------------------------------------------------------------------------|
| CHANNEL_ID            | NUMBER     |        | 18        | Yes      | Primary key of Channel Setup                                                                  |
| BUSINESS_GROUP_ID     | NUMBER     |        | 18        | Yes      | Foreign key to HR_ALL_ORGANIZATION_UNITS                                                      |
| EMAIL_ID              | VARCHAR2   | 240    |           | Yes      | Email Associated to the Channel                                                                 |
| CODE                  | VARCHAR2   | 240    |           | Yes      | Unique User Defined Code to Identify the Channel                                              |
| TYPE                  | VARCHAR2   | 240    |           | Yes      | Identify the Type of the Channel. Possible Values Are Private, Public, Directs and Organization |
| DEPENDENT_CHANNEL_ID  | NUMBER     |        | 18        |          | Corresponding Channel Associated for Directs and Organization Channel                         |
| ENABLED               | VARCHAR2   | 30     |           | Yes      | Indicates if the Channel is Enabled or Not                                                    |
| PAGENAME              | VARCHAR2   | 1000   |           |          | Indicate the page using the channel                                                             |
| INCOMING_SERVER_PROTOCOL | VARCHAR2   | 30     |           |          | Incoming Server Protocol                                                                      |
| INCOMING_SERVER_HOST  | VARCHAR2   | 4000   |           |          | Incoming Server Host Name                                                                     |
| INCOMING_SERVER_PORT  | NUMBER     |        | 18        |          | Incoming Server Port Number                                                                   |
| INCOMING_SERVER_AUTH_TYPE | VARCHAR2   | 30     |           |          | Incoming Server Authorization Type                                                            |
| INCOMING_SERVER_AUTH_KEY | VARCHAR2   | 1000   |           |          | Incoming Server Authorization Key                                                             |
| INCOMING_SERVER_AUTH_VALUE | CLOB       |        |           |          | Incoming Server Authorization Value                                                           |
| INCOMING_SERVER_BEARER_TOKEN | CLOB       |        |           |          | Incoming Server Authorization Bearer Token                                                    |
| INCOMING_SERVER_SSL   | VARCHAR2   | 30     |           |          | Whether or Not to Enable SSL When Connecting to the Incoming Server.                          |
| OUTGOING_SERVER_PROTOCOL | VARCHAR2   | 30     |           |          | Outgoing Server Protocol                                                                      |
| OUTGOING_SERVER_HOST  | VARCHAR2   | 4000   |           |          | Outgoing Server Host Name                                                                     |
| OUTGOING_SERVER_PORT  | NUMBER     |        | 18        |          | Outgoing Server Port Number                                                                   |
| OUTGOING_SERVER_AUTH_TYPE | VARCHAR2   | 30     |           |          | Outgoing Server Authorization Type                                                            |
| OUTGOING_SERVER_AUTH_KEY | VARCHAR2   | 1000   |           |          | Outgoing Server Authorization Key                                                             |
| OUTGOING_SERVER_AUTH_VALUE | CLOB       |        |           |          | Outgoing Server Authorization Value                                                           |
| OUTGOING_SERVER_BEARER_TOKEN | CLOB       |        |           |          | Outgoing Server Authorization Bearer Token                                                    |
| RECEIVE_FOLDER        | VARCHAR2   | 1000   |           |          | The name of the email folder the driver is polling messages from.                             |
| OBJECT_VERSION_NUMBER | NUMBER     |        | 9         | Yes      | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| CREATED_BY            | VARCHAR2   | 64     |           | Yes      | Who column: indicates the user who created the row.                                           |
| CREATION_DATE         | TIMESTAMP  |        |           | Yes      | Who column: indicates the date and time of the creation of the row.                           |
| LAST_UPDATED_BY       | VARCHAR2   | 64     |           | Yes      | Who column: indicates the user who last updated the row.                                      |
| LAST_UPDATE_DATE      | TIMESTAMP  |        |           | Yes      | Who column: indicates the date and time of the last update of the row.                        |
| LAST_UPDATE_LOGIN     | VARCHAR2   | 32     |           |          | Who column: indicates the session login associated to the user who last updated the row.      |

### Indexes
| Index                 | Uniqueness | Tablespace | Columns                                  |
|-----------------------|------------|------------|------------------------------------------|
| HRT_CHANNEL_SETUP_B_U1 | Unique     | Default    | CHANNEL_ID, BUSINESS_GROUP_ID            |
| HRT_CHANNEL_SETUP_B_U2 | Unique     | Default    | BUSINESS_GROUP_ID, CODE                  |
```

--------------------------------

### SQL Query Example for PAY_FLOW_TASKS_VL

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/payflowtasksvl-4394

Example SQL statement to query the PAY_FLOW_TASKS_VL view, joining with the translation table to get localized names.

```APIDOC
## GET /websites/oracle_en_cloud_saas_human-resources_oedmh/PAY_FLOW_TASKS_VL/query

### Description
This endpoint provides an example SQL query to retrieve flow task details from the PAY_FLOW_TASKS_VL view, including localized task names.

### Method
GET

### Endpoint
/websites/oracle_en_cloud_saas_human-resources_oedmh/PAY_FLOW_TASKS_VL/query

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
None

### Response
#### Success Response (200)
- **SQL_Statement** (string) - The example SQL query.

#### Response Example
{
  "SQL_Statement": "SELECT b.FLOW_TASK_ID, b.BASE_FLOW_TASK_ID, b.BASE_FLOW_TASK_NAME, b.MODULE_ID, b.OBJECT_VERSION_NUMBER, b.BASE_TASK_ID, b.BASE_FLOW_ID, b.DEST_UI_URL, b.CATEGORY_TYPE, b.SUB_CATEGORY_TYPE, b.PRE_CUSTOM_SERVICE, b.POST_CUSTOM_SERVICE, b.OFFSET_VALUE, b.OFFSET_FLOW_PARAMETER_ID, b.LEGISLATIVE_DATA_GROUP_ID, b.ENTERPRISE_ID, b.LEGISLATION_CODE, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATED_BY, b.CREATION_DATE, b.START_DATE_OFFSET_ID, b.START_DATE_OFFSET_VALUE, b.START_NOTIF_FLAG, b.END_NOTIF_FLAG, b.OVERDUE_NOTIF_FLAG, b.WARNING_NOTIF_FLAG, b.ERROR_NOTIF_FLAG, b.START_SCH_TIME_DEF_ID, tl.FLOW_TASK_NAME, tl.CHECKLIST_NAME, tl.DESCRIPTION, b.FORMULA_ID, b.START_SCH_FORMULA_ID, b.SUBMITTING_USER_FLAG, b.SGUID SGUID, b.ESS_REQUEST_CATEGORY, b.IGNORE_PREREQ_FLAG, b.EMP_ALERT_CODE, b.CMPLETD_ALRTS_NOTIF_FLAG, b.CRITICAL_ALERTS_NOTIF_FLAG, b.CORR_PROCESSES_NOTIF_FLAG, b.OUTBOUND_ENABLED_FLAG, b.INACTIVE_FLAG FROM PAY_FLOW_TASKS b, PAY_FLOW_TASKS_TL tl WHERE b.FLOW_TASK_ID = tl.FLOW_TASK_ID AND USERENV('LANG') = tl.LANGUAGE"
}
```

--------------------------------

### PER_EDIT_NAME_SETUP_TL Table Information

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/pereditnamesetuptl-4720

This section details the PER_EDIT_NAME_SETUP_TL table, which holds translatable settings for name configurations. It includes schema information, primary key details, a list of all columns with their data types and constraints, and information about the table's indexes.

```APIDOC
## Table: PER_EDIT_NAME_SETUP_TL

### Description
This table contains translatable information about the name field's configuration.

### Details
- **Schema**: FUSION
- **Object owner**: PER
- **Object type**: TABLE
- **Tablespace**: REFERENCE

### Primary Key
- **Name**: PER_EDIT_NAME_SETUP_TL_PK
- **Columns**: EDIT_NAME_SETUP_ID, LANGUAGE

### Columns
- **EDIT_NAME_SETUP_ID** (NUMBER) - Not-null - Part of primary key (also foreign key to base table)
- **ENTERPRISE_ID** (NUMBER) - Not-null - Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
- **LANGUAGE** (VARCHAR2) - Not-null - Indicates the code of the language into which the contents of the translatable columns are translated.
- **SOURCE_LANG** (VARCHAR2) - Not-null - Indicates the code of the language in which the contents of the translatable columns were originally created.
- **PROMPT** (VARCHAR2) - Nullable - The prompt to be given for the particular column
- **OBJECT_VERSION_NUMBER** (NUMBER) - Not-null - Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
- **CREATED_BY** (VARCHAR2) - Not-null - Who column: indicates the user who created the row.
- **CREATION_DATE** (TIMESTAMP) - Not-null - Who column: indicates the date and time of the creation of the row.
- **LAST_UPDATED_BY** (VARCHAR2) - Not-null - Who column: indicates the user who last updated the row.
- **LAST_UPDATE_DATE** (TIMESTAMP) - Not-null - Who column: indicates the date and time of the last update of the row.
- **LAST_UPDATE_LOGIN** (VARCHAR2) - Nullable - Who column: indicates the session login associated to the user who last updated the row.
- **SEED_DATA_SOURCE** (VARCHAR2) - Nullable - Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
- **ORA_SEED_SET1** (VARCHAR2) - Not-null - Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
- **ORA_SEED_SET2** (VARCHAR2) - Not-null - Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

### Indexes
- **PER_EDIT_NAME_SETUP_TL_PK** (Unique) - Tablespace: Default - Columns: EDIT_NAME_SETUP_ID, LANGUAGE, ORA_SEED_SET1
- **PER_EDIT_NAME_SETUP_TL_PK1** (Unique) - Tablespace: Default - Columns: EDIT_NAME_SETUP_ID, LANGUAGE, ORA_SEED_SET2
```

--------------------------------

### Oracle SQL: Get Activity Date for Classes and Specializations

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/wlflearncompletiondetailsv-4205

This SQL snippet retrieves the start date for classes or specializations. For specializations, it queries the start date of the associated course.

```SQL
(CASE WHEN ( parentlearningitemdeo.learning_item_type = 'ORA_CLASS') THEN (learningitemdeo.START_DATE) WHEN ( parentlearningitemdeo.learning_item_type = 'ORA_SPECIALIZATION') THEN (SELECT course_li.start_date from wlf_learning_items_f course_li where trunc(sysdate) between course_li.effective_start_date and course_li.effective_end_date and rownum=1) ELSE NULL END) AS ACTIVITY_DATE
```

--------------------------------

### PER_PERSON_TYPES_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/perpersontypesvl-4281

A sample SQL query to retrieve data from the PER_PERSON_TYPES_VL view, joining with the translation table to get user-friendly names.

```APIDOC
## Query Example for PER_PERSON_TYPES_VL

### SQL Statement
```sql
SELECT B.ROWID ROW_ID, B.PERSON_TYPE_ID, B.BUSINESS_GROUP_ID, B.ACTIVE_FLAG, B.DEFAULT_FLAG, B.SYSTEM_PERSON_TYPE, T.USER_PERSON_TYPE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.SEEDED_PERSON_TYPE_KEY, B.OBJECT_VERSION_NUMBER, B.MODULE_ID, B.SGUID SGUID FROM PER_PERSON_TYPES B, PER_PERSON_TYPES_TL T WHERE B.PERSON_TYPE_ID = T.PERSON_TYPE_ID AND T.LANGUAGE = USERENV('LANG')
```

### Description
This SQL statement retrieves person type details along with their translated user-friendly names based on the current user's language setting.
```

--------------------------------

### HRT_CHANNEL_SETUP_VL View Columns

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtchannelsetupvl-3456

Lists the columns available in the HRT_CHANNEL_SETUP_VL view.

```APIDOC
## View HRT_CHANNEL_SETUP_VL Columns

### Description
Lists all columns available in the HRT_CHANNEL_SETUP_VL view, with their data types and descriptions.

### Method
GET

### Endpoint
/websites/oracle_en_cloud_saas_human-resources_oedmh/tables-and-views/HRT_CHANNEL_SETUP_VL/columns

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
None

### Response
#### Success Response (200)
- **Name** (string) - The name of the column.
- **Type** (string) - The data type of the column.
- **Description** (string) - A brief description of the column's purpose.

#### Response Example
```json
[
  {
    "Name": "CHANNEL_ID",
    "Type": "NUMBER",
    "Description": "Unique identifier for the channel."
  },
  {
    "Name": "BUSINESS_GROUP_ID",
    "Type": "NUMBER",
    "Description": "Identifier for the business group."
  },
  {
    "Name": "EMAIL_ID",
    "Type": "VARCHAR2",
    "Description": "Email address associated with the channel."
  },
  {
    "Name": "CODE",
    "Type": "VARCHAR2",
    "Description": "Code representing the channel type."
  },
  {
    "Name": "TYPE",
    "Type": "VARCHAR2",
    "Description": "Type of the channel."
  },
  {
    "Name": "DEPENDENT_CHANNEL_ID",
    "Type": "NUMBER",
    "Description": "Identifier for a dependent channel."
  },
  {
    "Name": "ENABLED",
    "Type": "VARCHAR2",
    "Description": "Indicates if the channel is enabled (e.g., 'Y' or 'N')."
  },
  {
    "Name": "PAGENAME",
    "Type": "VARCHAR2",
    "Description": "Name of the associated page."
  },
  {
    "Name": "INCOMING_SERVER_PROTOCOL",
    "Type": "VARCHAR2",
    "Description": "Protocol for incoming server."
  },
  {
    "Name": "INCOMING_SERVER_HOST",
    "Type": "VARCHAR2",
    "Description": "Hostname for the incoming server."
  },
  {
    "Name": "INCOMING_SERVER_PORT",
    "Type": "NUMBER",
    "Description": "Port number for the incoming server."
  },
  {
    "Name": "INCOMING_SERVER_AUTH_TYPE",
    "Type": "VARCHAR2",
    "Description": "Authentication type for the incoming server."
  },
  {
    "Name": "INCOMING_SERVER_AUTH_KEY",
    "Type": "VARCHAR2",
    "Description": "Authentication key for the incoming server."
  },
  {
    "Name": "INCOMING_SERVER_AUTH_VALUE",
    "Type": "VARCHAR2",
    "Description": "Authentication value for the incoming server."
  },
  {
    "Name": "INCOMING_SERVER_BEARER_TOKEN",
    "Type": "VARCHAR2",
    "Description": "Bearer token for incoming server authentication."
  },
  {
    "Name": "INCOMING_SERVER_SSL",
    "Type": "VARCHAR2",
    "Description": "Indicates if SSL is enabled for the incoming server."
  },
  {
    "Name": "OUTGOING_SERVER_PROTOCOL",
    "Type": "VARCHAR2",
    "Description": "Protocol for outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_HOST",
    "Type": "VARCHAR2",
    "Description": "Hostname for the outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_PORT",
    "Type": "NUMBER",
    "Description": "Port number for the outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_AUTH_TYPE",
    "Type": "VARCHAR2",
    "Description": "Authentication type for the outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_AUTH_KEY",
    "Type": "VARCHAR2",
    "Description": "Authentication key for the outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_AUTH_VALUE",
    "Type": "VARCHAR2",
    "Description": "Authentication value for the outgoing server."
  },
  {
    "Name": "OUTGOING_SERVER_BEARER_TOKEN",
    "Type": "VARCHAR2",
    "Description": "Bearer token for outgoing server authentication."
  },
  {
    "Name": "RECEIVE_FOLDER",
    "Type": "VARCHAR2",
    "Description": "Folder for receiving data."
  },
  {
    "Name": "NAME",
    "Type": "VARCHAR2",
    "Description": "Name of the channel."
  },
  {
    "Name": "DESCRIPTION",
    "Type": "VARCHAR2",
    "Description": "Description of the channel."
  },
  {
    "Name": "OBJECT_VERSION_NUMBER",
    "Type": "NUMBER",
    "Description": "Concurrency control number."
  },
  {
    "Name": "CREATED_BY",
    "Type": "VARCHAR2",
    "Description": "User who created the record."
  },
  {
    "Name": "CREATION_DATE",
    "Type": "DATE",
    "Description": "Date the record was created."
  },
  {
    "Name": "LAST_UPDATED_BY",
    "Type": "VARCHAR2",
    "Description": "User who last updated the record."
  },
  {
    "Name": "LAST_UPDATE_DATE",
    "Type": "DATE",
    "Description": "Date the record was last updated."
  },
  {
    "Name": "LAST_UPDATE_LOGIN",
    "Type": "VARCHAR2",
    "Description": "Login associated with the last update."
  }
]
```
```

--------------------------------

### SQL Query: Retrieve Eligibility Profile Details

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/bendiagffatchmntg2v-3580

This SQL query retrieves details for 'Eligy Prfl' (Eligibility Profile) objects from BEN_ELIG_POE_PRTE and BEN_ELIG_SCHEDD_HRS_PRTE tables. It joins with FF_FORMULAS_F and FF_FORMULA_TYPES to get formula information. Effective dates are set to NULL.

```sql
SELECT NAME "Object Name", 'Eligy Prfl' "Object Type", 'BEN_ELIG_POE_PRTE' "Table Name", 'RNDG_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", TO_DATE(NULL) "Effective Start Date", TO_DATE(NULL) "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_ELIGY_PRFL ELP,BEN_ELIG_POE_PRTE EPP, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE ELP.ELIGY_PRFL_ID=EPP.ELIGY_PRFL_ID AND EPP.RNDG_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Eligy Prfl' "Object Type", 'BEN_ELIG_SCHEDD_HRS_PRTE' "Table Name", 'ROUNDING_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", TO_DATE(NULL) "Effective Start Date", TO_DATE(NULL) "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_ELIGY_PRFL ELP,BEN_ELIG_SCHEDD_HRS_PRTE ESHP, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE ELP.ELIGY_PRFL_ID=ESHP.ELIGY_PRFL_ID AND ESHP.ROUNDING_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID
```

--------------------------------

### HWM_EXT_ACT_ALLOC_ENTRY_V Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hwmextactallocentryv-4186

Example SQL query to retrieve data from the HWM_EXT_ACT_ALLOC_ENTRY_V view.

```APIDOC
## VIEW HWM_EXT_ACT_ALLOC_ENTRY_V Query

### Description
Provides an example SQL statement for querying the HWM_EXT_ACT_ALLOC_ENTRY_V view to retrieve allocation details.

### Method
SQL QUERY

### Endpoint
N/A (Database View)

### Parameters
None

### Request Example
None

### Response
#### Success Response (200)
- **SQL_Statement** (string) - The SQL query for the view.

#### Response Example
```sql
SELECT alloc.resource_ID, alloc.allocation_date, alloc.TM_ACT_ALLOC_ID allocation_id, alloc.TM_ACT_ALLOC_VERSION alloc_data_version, alloc.duration/60 allocation_duration, 'ADD' as action FROM HWM_TM_ACT_ALLOCS alloc, HWM_TM_ACT_ALLOC_STATUSES stat WHERE stat.TM_ACT_ALLOC_ID = alloc.TM_ACT_ALLOC_ID AND stat.TM_ACT_ALLOC_VERSION = alloc.TM_ACT_ALLOC_VERSION AND systimestamp BETWEEN stat.date_from AND stat.date_to AND alloc.latest_version='Y' AND stat.allocation_status='ORA_HWM_AA_VALID' AND stat.TRANSFER_STATUS='ORA_HWM_AA_STAT_NOT_TRANS' AND alloc.delete_flag='N' UNION ALL SELECT alloc.resource_ID, alloc.allocation_date, alloc.TM_ACT_ALLOC_ID allocation_id, alloc.TM_ACT_ALLOC_VERSION alloc_data_version, -1 * (alloc.duration/60) as allocation_duration, 'REMOVE' as action FROM HWM_TM_ACT_ALLOCS alloc, HWM_TM_ACT_ALLOC_STATUSES stat WHERE stat.TM_ACT_ALLOC_ID = alloc.TM_ACT_ALLOC_ID AND stat.TM_ACT_ALLOC_VERSION = alloc.TM_ACT_ALLOC_VERSION AND systimestamp BETWEEN stat.date_from AND stat.date_to AND alloc.latest_version='N' AND stat.TRANSFER_STATUS='ORA_HWM_AA_STAT_TRANS' AND alloc.TM_ACT_ALLOC_VERSION IN (SELECT max(aatab.TM_ACT_ALLOC_VERSION) FROM HWM_TM_ACT_ALLOCS aatab, HWM_TM_ACT_ALLOC_STATUSES stattab WHERE alloc.TM_ACT_ALLOC_ID = aatab.TM_ACT_ALLOC_ID AND aatab.TM_ACT_ALLOC_ID = stattab.TM_ACT_ALLOC_ID AND aatab.TM_ACT_ALLOC_VERSION = stattab.TM_ACT_ALLOC_VERSION AND systimestamp BETWEEN stat.date_from AND stat.date_to AND stattab.transfer_status='ORA_HWM_AA_STAT_TRANS' AND aatab.latest_version='N')
```
```

--------------------------------

### Example Query for HWM_ALLOCATION_LN_ATRBS_DTL_X

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hwmallocationlnatrbsdtlx-3059

Provides an example SQL query to retrieve data from the HWM_ALLOCATION_LN_ATRBS_DTL_X view by joining with related tables.

```APIDOC
## Query for HWM_ALLOCATION_LN_ATRBS_DTL_X

### Description
Example SQL statement to query the HWM_ALLOCATION_LN_ATRBS_DTL_X view, joining with related tables HWM_ALLOCATIONS_HDR_vl, HWM_ALLOCATION_RULES_F, and HWM_ALLOCATION_LINES_F.

### SQL Statement
```sql
SELECT 
    hdr.ALLOCATION_ID, 
    hdr.EFFECTIVE_START_DATE, 
    hdr.EFFECTIVE_END_DATE, 
    hdr.OBJECT_VERSION_NUMBER, 
    hdr.ENTERPRISE_ID, 
    hdr.ALLOCATION_NAME, 
    hdr.DESCRIPTION, 
    rul.ALLOCATION_RULE_ID, 
    rul.ALLOCATION_RULE_PRIORITY, 
    rul.TCAT_ID, 
    rul.ALLOCATION_TYPE, 
    rul.RUN_SUMMATION_LEVEL, 
    lne.ALLOCATION_LINE_ID, 
    lne.ALLOCATION_LINE_PRIORITY, 
    lne.ALLOCATION_VALUE, 
    lat.ALLOCATION_LN_ATRB_ID, 
    lat.TM_ATRB_FLD_ID, 
    lat.ATRB_FLD_NAME, 
    lat.ATRB_DATA_TYPE, 
    lat.ATRB_VALUE_TEXT, 
    lat.ATRB_VALUE_NUMBER, 
    lat.ATRB_VALUE_TIMESTAMP, 
    lat.DATA_LEVEL 
FROM 
    HWM_ALLOCATIONS_HDR_vl hdr, 
    HWM_ALLOCATION_RULES_F rul, 
    HWM_ALLOCATION_LINES_F lne, 
    HWM_ALLOCATION_LN_ATRBS_F lat 
WHERE 
    hdr.ALLOCATION_ID = rul.ALLOCATION_ID 
    AND hdr.EFFECTIVE_START_DATE = rul.EFFECTIVE_START_DATE 
    AND hdr.EFFECTIVE_END_DATE = rul.EFFECTIVE_END_DATE 
    AND rul.ALLOCATION_RULE_ID = lne.ALLOCATION_RULE_ID 
    AND hdr.EFFECTIVE_START_DATE = lne.EFFECTIVE_START_DATE 
    AND hdr.EFFECTIVE_END_DATE = lne.EFFECTIVE_END_DATE 
    AND lne.ALLOCATION_LINE_ID = lat.ALLOCATION_LINE_ID 
    AND hdr.EFFECTIVE_START_DATE = lat.EFFECTIVE_START_DATE 
    AND hdr.EFFECTIVE_END_DATE = lat.EFFECTIVE_END_DATE;
```

--------------------------------

### Query PER_POS_HIERARCHY_F_V in SQL

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/perposhierarchyfv-3649

This SQL query retrieves position hierarchy information from the PER_POS_HIERARCHY_F_V view. It joins with hr_all_positions_f to get position codes and parent position codes, applying date criteria for effective start and end dates. The query also includes optimizations like FIRST_ROWS and USE_NL hints.

```sql
select /*+ FIRST_ROWS(20) USE_NL(h p pp)*/p.position_code pos_code, pp.position_code parent_pos_code, to_char(h.effective_start_date,'DD-MON-YYYY') ESD,to_char(h.effective_end_date,'DD-MON-YYYY') EED, h.position_id,h.parent_position_id,h.business_group_id,h.created_by,h.creation_date, h.last_updated_by,h.last_update_date,upper(p.position_code) pos_code_upper, upper(pp.position_code) parent_pos_code_upper,h.position_hierarchy_id,h.object_version_number,h.action_occurrence_id from PER_POSITION_HIERARCHY_F h, hr_all_positions_f p, hr_all_positions_f pp where h.position_id=p.position_id(+) and h.business_group_id=p.business_group_id(+) and h.parent_position_id=pp.position_id(+) and h.business_group_id=pp.business_group_id(+) and h.effective_start_date between p.effective_start_date(+) and p.effective_end_date(+) and h.effective_start_date between pp.effective_start_date(+) and pp.effective_end_date(+) order by p.position_code desc,h.position_id desc,h.effective_start_date,h.last_update_date
```

--------------------------------

### SQL Query: Retrieve Derived Factor Details from BEN_AGE_FCTR and BEN_COMP_LVL_FCTR

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/bendiagffatchmntg2v-3580

This SQL query retrieves details for 'Derived Factor' objects from BEN_AGE_FCTR and BEN_COMP_LVL_FCTR tables. It joins these tables with FF_FORMULAS_F and FF_FORMULA_TYPES to get formula information and type names. Effective dates are set to NULL for these derived factors.

```sql
SELECT NAME "Object Name", 'Derived Factor' "Object Type", 'BEN_AGE_FCTR' "Table Name", 'RNDG_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", TO_DATE(NULL) "Effective Start Date", TO_DATE(NULL) "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_AGE_FCTR AGF, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE AGF.RNDG_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Derived Factor' "Object Type", 'BEN_COMP_LVL_FCTR' "Table Name", 'RNDG_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", TO_DATE(NULL) "Effective Start Date", TO_DATE(NULL) "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_COMP_LVL_FCTR CLF, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE CLF.RNDG_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID
```

--------------------------------

### HRT_CHANNEL_SETUP_VL View Details

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtchannelsetupvl-3456

Provides details about the HRT_CHANNEL_SETUP_VL view, including its schema, object owner, and object type.

```APIDOC
## View HRT_CHANNEL_SETUP_VL

### Description
This view provides setup information for HR channels.

### Method
GET

### Endpoint
/websites/oracle_en_cloud_saas_human-resources_oedmh/tables-and-views/HRT_CHANNEL_SETUP_VL

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
None

### Response
#### Success Response (200)
- **Schema** (string) - The schema of the view (e.g., FUSION).
- **Object owner** (string) - The owner of the object (e.g., HRT).
- **Object type** (string) - The type of the object (e.g., VIEW).

#### Response Example
```json
{
  "Schema": "FUSION",
  "Object owner": "HRT",
  "Object type": "VIEW"
}
```
```

--------------------------------

### HRT_NOTIF_SETUP_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/hrtnotifsetupvl-3748

Provides a sample SQL query to retrieve data from the HRT_NOTIF_SETUP_VL view.

```APIDOC
## Query Example: HRT_NOTIF_SETUP_VL

### Description
This is a sample SQL query to fetch notification setup details, including translated labels and descriptions, for the current user's language.

### SQL Statement
```sql
SELECT 
    NS.NOTIF_ID, 
    NS.BUSINESS_GROUP_ID, 
    NS.NOTIF_NAME, 
    NS.NOTIF_ENABLED, 
    NS.PRODUCT_CODE, 
    NSTL.NOTIF_LABEL, 
    NSTL.DESCRIPTION, 
    NS.MODULE_ID, 
    NS.OBJECT_VERSION_NUMBER, 
    NS.CREATED_BY, 
    NS.CREATION_DATE, 
    NS.LAST_UPDATED_BY, 
    NS.LAST_UPDATE_DATE, 
    NS.LAST_UPDATE_LOGIN 
FROM 
    HRT_NOTIF_SETUP_B NS, 
    HRT_NOTIF_SETUP_TL NSTL 
WHERE 
    NS.NOTIF_ID = NSTL.NOTIF_ID 
    AND NS.BUSINESS_GROUP_ID = NSTL.BUSINESS_GROUP_ID 
    AND NSTL.LANGUAGE = USERENV('LANG')
```
```

--------------------------------

### FF_FUNCTIONS Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/fffunctions-3048

An example SQL query to retrieve data from the FF_FUNCTIONS view.

```APIDOC
## FF_FUNCTIONS Query Example

### Query
```sql
SELECT FF_FUNCTIONS_B.FUNCTION_ID FUNCTION_ID, FF_FUNCTIONS_B.FUNCTION_KEY FUNCTION_KEY, FF_FUNCTIONS_B.BASE_FUNCTION_NAME NAME, FF_FUNCTIONS_B.ALIAS_NAME ALIAS_NAME, FF_FUNCTIONS_B.INTERPRETER_CALL_FLAG INTERPRETER_CALL_FLAG, FF_FUNCTIONS_B.DEFINITION DEFINITION, FF_FUNCTIONS_B.DATA_TYPE DATA_TYPE, FF_FUNCTIONS_B.ENTERPRISE_ID ENTERPRISE_ID, FF_FUNCTIONS_B.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, FF_FUNCTIONS_B.LEGISLATION_CODE LEGISLATION_CODE, FF_FUNCTIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FF_FUNCTIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, FF_FUNCTIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, FF_FUNCTIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FF_FUNCTIONS_B.CREATION_DATE CREATION_DATE, FF_FUNCTIONS_B.CREATED_BY CREATED_BY, FF_FUNCTIONS_B.MODULE_ID MODULE_ID FROM FF_FUNCTIONS_B WITH CHECK OPTION
```
```

--------------------------------

### IRC_CAMP_POST_CONTENT_VL Query Example

Source: https://docs.oracle.com/en/cloud/saas/human-resources/oedmh/irccamppostcontentvl-4206

Provides an example SQL query to retrieve data from the IRC_CAMP_POST_CONTENT_VL view.

```APIDOC
## GET /websites/oracle_en_cloud_saas_human-resources_oedmh/irc_camp_post_content_vl/query

### Description
Provides an example SQL query to fetch data from the IRC_CAMP_POST_CONTENT_VL view, joining with the translation table to get localized titles and descriptions.

### Method
GET

### Endpoint
/websites/oracle_en_cloud_saas_human-resources_oedmh/irc_camp_post_content_vl/query

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
None

### Response
#### Success Response (200)
- **sql_statement** (string) - The SQL statement for querying the view.

#### Response Example
```json
{
  "sql_statement": "SELECT B.POST_CONTENT_ID, B.ASSET_ID, B.PRIMARY_LINK_TYPE_CODE, B.PRIMARY_ASSET_URL_ID, B.SECONDARY_LINK_TYPE_CODE, B.SECONDARY_ASSET_URL_ID, B.IMAGE_URL, TL.TITLE, TL.DESCRIPTION, TL.PRIMARY_LABEL, TL.SECONDARY_LABEL, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM IRC_CAMP_POST_CONTENT_B B, IRC_CAMP_POST_CONTENT_TL TL WHERE B.POST_CONTENT_ID = TL.POST_CONTENT_ID AND TL.LANGUAGE = USERENV('LANG')"
}
```
```
Tokens:
Raw