Showing posts with label Fusion PA Tables. Show all posts
Showing posts with label Fusion PA Tables. Show all posts
Monday, 4 March 2019

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:

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:

Query to Find Projects Not Accruing Revenue in Oracle Fusion

›
--**** Project Not Accruing Revenue Due to Expenditure Exception ****-- SELECT PE.accounting_period AS GL_PERIOD       ,OKH.contract_number...
Monday, 24 September 2018

EBS to FUSION PA (Project Accounting) Table Changes

›
EBS Tables -----------------------------------------  FUSION Tables ------------------------------------------- PA_PRO...
9 comments: