SELECT pou.NAME carrying_out_org_name ,ppa.NAME project_name ,ppa.segment1 project_num ,ppa.segment1 project_number –,TO_CHAR(ppa.completion_date, ‘DD-MON-YYYY’, ‘NLS_DATE_LANGUAGE = american’) completion_date –,ppa.description –,TO_CHAR(ppp.end_date_active, ‘DD-MON-YYYY’,…
Read MorePurpose of this report is to display Project billable hours for Internal ================================================= /* Formatted on 2018/07/30 15:40 (Formatter Plus v4.8.8) */ SELECT gl_period, expenditure_org, project_number, project_name, …
Read MoreGo to File->Info->Properties>Advanced Settings and follow the Screen shot A and Screen shot b Screen shot A In the Custom Tab add one XDO as xdo-pdf-open-password and in the value filed type the…
Read MoreInclude User Notifications or Custom Messages and Error Messages in Oracle APEX’s default Success and Error Message style. Default Success message : Default Error message : Steps in APEX :…
Read MoreProcess of enabling users to quickly find and select from a list of values as they type, searching and filtering without Native text with auto-complete in APEX. This process works…
Read MoreEBS Tables—————————————– FUSION Tables——————————————- PA_PROJECTS_ALL —————————————– PJF_PROJECTS_ALL_B PJF_PROJECTS_ALL_TL——————————————- PA_PROJECT_TYPES_ALL —————————————– PJF_PROJECT_TYPES_B PJF_PROJECT_TYPES_TL——————————————- PA_PROJECT_STATUSES —————————————– PJF_PROJECT_STATUSES_B PJF_PROJECT_STATUSES_TL——————————————- PA_PROJECT_STATUS_CONTROLS—————————————– PJF_PROJ_STATUS_CONTROLS——————————————- PA_PROJECT_ACCUM_ACTUALS—————————————– PJO_PROJECT_PLAN_ACTUALS——————————————- PA_TASKS —————————————– PJF_PROJ_ELEMENTS_B PJF_PROJ_ELEMENTS_TL PJF_TASKS_V——————————————- PA_BUDGET_TYPES—————————————– PJO_PLAN_TYPES_B——————————————- PA_EXPENDITURE_TYPES —————————————– PJF_EXP_TYPES_B…
Read MoreAPI used for EAM preventive collection plan creation and its Elements insertion. Basically this QA tables are used for capturing daily meter reading of asset in EAM and then This…
Read MoreAPI used for while generating Preventive Maintenance work orders for an asset. This API used to insert last service meter reading for an asset while generating work orders. …
Read MoreAPI used to create EAM Construction Estimation headers and lines creation. This used in for creation any construction like building etc to estimate how much labour and how much cost…
Read MoreAPI used for to maintain asset in proper manner during work order generation. After generating work order for an asset . Users will follow the asset activities for an asset…
Read More