Oracle Fusion

Query to Find Project Estimation To Complete in Oracle Fusion

SELECT A.PROJECT_STATUS,       A.OPERATING_UNIT_NAME,       A.AGREEMENT_TYPE,       A.PROJECT_ORGANIZATION_NAME,       A.PROJECT_NUMBER,       A.PROJECT_NAME,       A.START_DATE,       A.COMPLETION_DATE,       A.TASK_NUMBER,       A.TASK_NAME,       A.PROJECT_CURRENCY,       ROUND(A.BUDGETED_REV_PROJ_CURR) BUDGETED_REV_PROJ_CURR,       ROUND(A.ACTUAL_REV_ITD_PRJ_CURR) ACTUAL_REV_ITD_PRJ_CURR,       ROUND(A.BILLABLE_HOURS_ACTUAL_ITD) BILLABLE_HOURS_ACTUAL_ITD,       ROUND(A.TOTAL_HOURS_ACTUAL_ITD) TOTAL_HOURS_ACTUAL_ITD,       A.FUNC_CURRENCY,       ROUND(A.ACTUAL_REV_ITD_FUNC_CURR) ACTUAL_REV_ITD_FUNC_CURR,        (ROUND (     ( (A.ACTUAL_REV_ITD_PRJ_CURR /…

Read More

Query to find AR Open Balance Of a Project in Oracle Fusion

WITH FUNCTION get_outstanding_amount (      p_payment_schedule_id       IN   NUMBER,      p_as_of_date                IN   DATE,      p_invoice_type              IN   VARCHAR2,      p_amt_due_remaining         IN   NUMBER,      p_amount_applied            IN   NUMBER,      p_amount_adjusted           IN   NUMBER,      p_amount_credited           IN   NUMBER,      p_amount_in_dispute         IN   NUMBER,      p_amount_adjusted_pending   IN  …

Read More

PROJECT UNBILLED BALANCES- FUSION

This report will display all project unbilled details. SELECT   ppa.project_id, ppa.segment1 project_number,           NVL ((SELECT pt.project_type                FROM pjf_project_types_tl pt, pjf_projects_all_vl…

Read More