Lease and Finance Management - EBS (MOSC)

MOSC Banner

LOV query for field Contract Line Type Service Contract -- Line -- Accounts --Line Type for Service

Hi Team,
Application : Service Contracts; Oracle Applications : 12.2.10
I am customizing LOV query for field 'Contract Line Type' (Service Contract --> Line --> Accounts --> Line Type) for 'Service Agreement'. Currently, it is showing two values (i.e. Service/Usage). As per our business user's requirement, only 'Service' should come.
I am doing form personalization for this and creating new record group for this having new sql as - 'select flv.meaning from apps.fnd_lookup_values_vl flv
where flv.lookup_type = 'OKC_LINE_TYPE' and lookup_code in ('SERVICE')'. This sql is giving value 'Service' in pl/sql developer, but not getting applied in form personalization

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