CREATE OR REPLACE PACKAGE BODY XX_IMPORT_EMPLOYEES_NEW IS  PROCEDURE XX_create_employee IS   CURSOR Cur0 IS     SELECT    MESSAGE,ROWID     FROM      XX_PER_ALL_PEOPLE_F_INT     WHERE    [...]

— GL & XLA Query SELECT glcc.concatenated_segments ACCOUNT, ac.customer_number, ac.customer_name, xlal.currency_code, xlal.accounted_dr accounted_dr, xlal.accounted_cr accounted_cr, [...]

Introduction: This SQL query is fetching the data of Tax reporting type code details by passing the tax regime. Cause of the issue: To find if any of the tax reporting type code is blank and that [...]

Introduction: This SQL query is fetching the data of India customer’s transaction with the company and the customer GST details. Cause of the issue: To find out the customers GST details with the [...]

 Query to get Projects and Tasks Details – Fusion SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DESCRIPTION ,PPA.START_DATE [...]

  Query to Fetch Employee’s Legal Employer SELECT papf.person_number,         hauft.NAME LegalEmployer FROM   HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, [...]

Introduction to workflow Tool from Oracle Works with Oracle Database PL/SQL Based Widely Used with Oracle Applications Can be Used Stand-Alone or with Oracle Apps Need of workflow Workflow can be [...]

We can sort data in XML report a group by any element within the group. Sort data based on Empno: Syntax: <?sort:Field_Name?><?Field_Name?> It sorts the data in ascending order by [...]

select a.menu_id , menu_name , c.responsibility_name , g.user_name , g.description from fnd_menu_entries a , fnd_menus b , fnd_responsibility_vl c , fnd_form_functions d , fnd_form_vl e , [...]

CREATE TABLE xxcus.XX_PO_HEADERS_STG ( INTERFACE_HEADER_ID NUMBER , BATCH_ID NUMBER, INTERFACE_SOURCE_CODE VARCHAR2(25), PROCESS_CODE VARCHAR2(25), ACTION VARCHAR2(25), GROUP_CODE VARCHAR2(25), [...]