EBS Customizations (MOSC)

MOSC Banner

OTL table value set -Trying to reference the person id for the current user in the WHERE clause

DDL of HXC_CUI_CUSTOM3_V view

-- new definition of view controlling cost center timesheet lov

  CREATE OR REPLACE FORCE VIEW "APPS"."HXC_CUI_CUSTOM3_V" ("DISPLAY_VALUE", "VALUE", "EFFECTIVE_START_DATE", "EFFECTIVE_END_DATE", "DIVISION_ID", "PERSON_ID") AS

  select scc.cost_center_code||'-'||scc.description "DisplayValue", scc.cost_center_id as "Value" , scc.effective_start_date, scc.effective_end_date, scc.division_id, papf.person_id

  from per_all_people_f papf, per_all_assignments_f paaf, hr_all_organization_units haou, PER_ASSIGNMENT_EXTRA_INFO paei, sjr_cost_centers scc, hr_lookups lkp

  where papf.person_id = paaf.person_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center