SELECT x.ei_latest_gl_period_name, x.r_company, x.ei_revenue_distributed_flag, x.ei_project_name, x.ei_project_number, x.ei_expenditure_type, x.ei_expenditure_category, x.ei_employee_name, x.ei_expenditure_item_date, x.ei_receipt_currency_code, …
Read More–**** Project Not Accruing Revenue Due to Expenditure Exception ****– SELECT PE.accounting_period AS GL_PERIOD ,OKH.contract_number ,OKL.line_number ,PPA.segment1 AS project_number ,PPA.name AS project_name ,PT.task_number ,PT.task_name ,PEI.expenditure_item_id trx_number ,PEC.expenditure_category_name ,NVL(PPN.full_name, PS.vendor_name) AS…
Read MoreWITH 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 Moreselect Entity,Business_unit,reporting_organization,EMPLOYEE_NUMBER,EMPLOYEE_NAME,EFFECTIVE_START_DATE,TOTAL_HOURS,BILLABLE_HOURS,CHARGEABLE_HOURS,EXPENDITURE_ENDING_DATE,YEAR_START_DATE, round((BILLABLE_HOURS/TOTAL_HOURS)*100,2) BILLABLE_PCT,round((CHARGEABLE_HOURS/TOTAL_HOURS)*100,2) CHARGEABLE_PCT ,normal_hours,effective_end_date from ( SELECT Entity,Business_unit, EMPLOYEE_NUMBER,EMPLOYEE_NAME,EFFECTIVE_START_DATE,TOTAL_HOURS,BILLABLE_HOURS,CHARGEABLE_HOURS,EXPENDITURE_ENDING_DATE, YEAR_START_DATE, round((BILLABLE_HOURS/TOTAL_HOURS)*100,2) BILLABLE_PCT,round((CHARGEABLE_HOURS/TOTAL_HOURS)*100,2) CHARGEABLE_PCT ,normal_hours,effective_end_date from ( select (SELECT fv.description …
Read MoreSELECT xep.NAME, — Legal Entity Name xjv.registration_code_le registration_code, xr.registration_number, hl.address1 …
Read More1. Link Between Legal Entity & Ledger along with Default Company Assigned in Legal Entity SELECT flex_segment_value ,gll.* FROM gl_legal_entities_bsvs gleb…
Read MoreProject wise PO details Reports SELECT ipd.project_number PROJECT_NUMBER, ipda.asset_tag_id TAG_NUMBER, translate(ipd.description,’ä’,’a’) Project_Desc, Translate(ipda.asset_desc,’ä’,’a’) Asset_Desc, — prh.segment1 req_number, …
Read MoreAdd Expense type in Expense template Navigation AP setup user à Setup à Invoice à Expense Report Templates Name Expense Category Tax Code GL Account Projects Expenditure Type Policy Schedule…
Read More<?xml version=”1.0″?> <dataTemplate name=”XX__AR_INVPRINT” description=”TW Invoice Printout for United States” defaultPackage=”XX_AR_INVPRINT_PKG” version=”1.0″> <parameters> <parameter name=”P_Report_Level” dataType = “character”></parameter> …
Read MoreReturn to Vendor of Purchase Order Receipts Script: Oracle EBS R12 Return to Vendor is done in two steps: “Return to Receiving” and then “Return to Vendor”. Follow below steps…
Read More