Showing posts with label Fusion. Show all posts
Showing posts with label Fusion. Show all posts
Thursday, 19 September 2019

Script for getting Sales Tax Transactions

›
SELECT DISTINCT aia.invoice_date transaction_date,                 aia.invoice_num transaction_number, hou.NAME company_name,             ...
2 comments:

Script for Extracting InterCompany batch details

›
This summary is not available. Please click here to view the post.
2 comments:

Script to get Project Listing

›
SELECT   pt.project_id, ppa.NAME project_name,          ppa.description project_description, ppa.segment1 project_number,          pt.tas...
1 comment:
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...

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_...