Lease and Finance Management - EBS (MOSC)

MOSC Banner

Service Contract Entitlement data

edited Oct 10, 2012 8:07PM in Lease and Finance Management - EBS (MOSC) 5 commentsAnswered
Hi,

I am looking for data extract from the oracle service contracts module with the list of entitlements correspond to active contracts of a particular group.

I tried with the following list of tables, but I am not able to get the place where the entitlement-service activity billing type being stored.

Also I observed when we modify the coverage plan in the contract and add entitlements (service activity billing type), it adds lots of lines in the okc_k_lines_b table

oks_k_headers_all_b

oks_k_lines_b

oks_coverages_v

oks_ent_coverages_v

Please help me to frame a SQL query for this data extract.

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