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 ,PPA.COMPLETION_DATE ,PPA.CLOSED_DATE ,PTV.TASK_NUMBER ,TO_CHAR(PTV.TASK_ID) TASK_ID ,TO_CHAR(PPA.CARRYING_OUT_ORGANIZATION_ID) ORGANIZATION_ID ,HRU.NAME ORGANIZATION_NAME ,PPT.PROJECT_TYPE PROJECT_TYPE ,PPA.GROUP_SPACE_TEMPLATE_NAME…
Read MoreQuery 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, HR_ORGANIZATION_UNITS_F_TL hauft, per_all_assignments_m paam, per_all_people_f papf WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID…
Read MoreIntroduction 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…
Read MoreWe 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 Default. If Order…
Read Moreselect 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 , fnd_user_resp_groups f , fnd_user…
Read MoreCREATE 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), ORG_ID NUMBER, DOCUMENT_TYPE_CODE VARCHAR2(25), DOCUMENT_SUBTYPE VARCHAR2(25), DOCUMENT_NUM VARCHAR2(20), PO_HEADER_ID NUMBER, RELEASE_NUM NUMBER, PO_RELEASE_ID…
Read MoreXML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdofx:expression?> for extended…
Read MoreSELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, fnd_menu_entries MENU, fnd_responsibility RES, fnd_responsibility_tl RESTL WHERE FORMSTL.user_form_name LIKE ‘%Workbench%’ AND FORMS.form_id = FORMSTL.form_id AND FUNC.form_id = FORMS.form_id…
Read MoreConditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if statement to define a simple condition; for example, if…
Read MorePlease make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read More