AP – Employee invoices query – FUSION
SELECT gp.period_name, (SELECT ‘Q’ …
Read MoreAP Supplier Invoices query – FUSION
SELECT gp.period_name, (SELECT ‘Q’ || quarter_num || ‘-WK’ …
Read MorePA – Project Revenue exception query
SELECT pcdl.prvdr_gl_period_name ei_latest_gl_period_name, gcc.segment1 r_company, peia.revenue_recognized_flag ei_revenue_distributed_flag, ppat.NAME ei_project_name, ppab.segment1 ei_project_number, pet.expenditure_type_name ei_expenditure_type, pec.expenditure_category_name ei_expenditure_category,…
Read MoreREVERSE CHARGE MECHANISM
Reverse charge is a mechanism where the recipient of the goods and/or services is liable to pay GST instead of the supplier. Normally, the supplier of goods or services pays…
Read MorePROJECT 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 MoreHCKT Hard Limit Reached Events in Fusion
Purpose of the report is to display project hours and hard-limit amount with interactive mode. with XXANSR_PA_EVENTS_cte as (SELECT evt.ROWID as “ROW_ID”, evt.event_id as “EVENT_ID”,…
Read MoreREVENUE TRANSFER REPORT (FUSION)
Purpose of this report is to derive all projects expenditure and event details with cost information. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number,…
Read MoreASSET DEPRECIATION LOGIC QUERY
This query fetches the details of those assets which are partially and fully depreciated. SELECT ASSET_CATEGORY_ID ,MAJOR_CATEGORY ,OPENING_DAY_ASSET_COST ,OPEN_ACC_ASSET_COST_FY …
Read MoreNEW ASSETS ADDITION QUERY
This query fetches the detailed information related to those assets which are added newly for a particular period. SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME …
Read MoreLeases which are expiring 15,30,60,180 days before respectively
This query fetches those leases which are going to expiry within 15,30,60,90,180 days respectively based on the parameter. SELECT GCC.segment4 SOL_ID ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME …
Read More