### 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')" } ``` ```