Monday, 4 March 2019

Query To Find Contracts With Revenue on Hold in Oracle Fusion

›
SELECT PPA.segment1 project_number     ,OCTV.name contracty_type     ,PPA.name project_name     ,HOU.name organization_name     ,PPA.projec...

Function To Get Bill Rate Of Employee in Specific Project in Oracle Fusion

›
FUNCTION get_bill_rate (       p_project_id IN NUMBER,           p_person_id  IN NUMBER    ) RETURN NUMBER AS   ln_bill_rate NUMBER; BEGIN ...
1 comment:

Query to Find AP Reimbursable Expenses in Oracle Fusion

›
WITH GET_PERIOD_AVG_RATE         AS (  SELECT gper.avg_rate,                      gsob.CURRENCY_CODE AS functional_currency,               ...
2 comments:

Fusion Query to get Revenue and billable hours of a Employee

›
SELECT pcdl.org_id employee_cost_org_id, pcdl.prvdr_gl_period_name gl_period,        pcdl.prvdr_pa_period_name,        NVL (pei.override_...

Query to Find NonBillable Expense in Oracle Fusion

›
SELECT pcdl.prvdr_gl_period_name gl_period,        trx_org.NAME expenditure_organization,        prb.project_id,        NVL (prb.segment1, ...
1 comment:

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...
1 comment:

Fusion Query to find Revenue Exceptions details for Expenditures

›
SELECT   x.ei_latest_gl_period_name, x.r_company,          x.ei_revenue_distributed_flag, x.ei_project_name,          x.ei_project_numbe...