SELECT PEI.expenditure_item_id ,PPA.segment1 project_number ,PPA.name project_name ,PPA.segment1||’-‘||pih.invoice_num invoice_number ,TO_CHAR(PIH.INVOICE_DATE, ‘DD-MON-YYYY’, ‘NLS_DATE_LANGUAGE = american’) INVOICE_DATE…
Read MoreSELECT prd.org_id employee_cost_org_id, prd.gl_period_name gl_period, NVL (pei.override_to_organization_id, pei.incurred_by_organization_id ) expenditure_org_id, trx_org.NAME expenditure_org, fnbu.bu_name,…
Read MoreWITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER, p_as_of_date IN DATE, p_invoice_type …
Read MoreCREATE OR REPLACE FUNCTION APPS.PN_NORM_EXP(p_payment_item_id number, p_ccid number) RETURN NUMBER IS l_accrued_amount number; l_cash_amount number; l_norm_exp number; l_max_item_id number; l_ps_id …
Read MoreCREATE OR REPLACE FUNCTION APPS.PN_CASH(p_payment_item_id number, p_ccid number) RETURN NUMBER IS l_cash_amount number; l_max_item_id number; l_ps_id number; BEGIN — select payment_schedule_id…
Read MoreCREATE OR REPLACE FUNCTION APPS.HR_GET_DEPENDENT(p_element_entry_id IN NUMBER, p_contact_number IN NUMBER, p_data_field IN VARCHAR2) RETURN VARCHAR2 IS l_contact_name VARCHAR2(300); CURSOR C1 IS SELECT DEP.Full_Name Contact_Full_Name, DEP.National_Identifier,…
Read MoreCREATE OR REPLACE FUNCTION APPS.Aging_Bucket_Due (P_CUST_ACCOUNT_ID IN NUMBER, P_AGING_BUCKET IN NUMBER) RETURN NUMBER IS l_bucket_balance NUMBER(10,2); BEGIN…
Read MoreSELECT gp.period_name, (SELECT ‘Q’ || quarter_num || ‘-WK’ …
Read MoreSELECT 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 More