DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKS_ENT_TXN_GROUPS_V

Object Details
Object Name: OKS_ENT_TXN_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_ENT_TXN_GROUPS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


List of transaction groups covered under coverage.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER
Yes System generated unique identifier. Primary key column of the table.
TXN_GROUP_ID NUMBER
Yes Transaction Group Identifier (Buiness Process)
COVERAGE_ID NUMBER

Internal Unique Identifier of a Coverage.
BUSINESS_PROCESS_ID NUMBER (15) Yes Business Process identifier for Service
BUSINESS_PROCESS_NAME VARCHAR2 (90) Yes Name of the transaction group
START_DATE DATE

The date the contract line(Business Process) becomes active
END_DATE DATE

The date the contract line(Business Process) expires
BILLING_PROFILE_ID VARCHAR2 (0)
Billing Profile Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTRACT_LINE_ID
,      TXN_GROUP_ID
,      COVERAGE_ID
,      BUSINESS_PROCESS_ID
,      BUSINESS_PROCESS_NAME
,      START_DATE
,      END_DATE
,      BILLING_PROFILE_ID
FROM APPS.OKS_ENT_TXN_GROUPS_V;

Dependencies

[top of page]

APPS.OKS_ENT_TXN_GROUPS_V references the following:

SchemaAPPS
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
PL/SQL PackageOKS_ENTITLEMENTS_PVT - show dependent code
SynonymOKS_K_LINES_B
ViewOKX_BUS_PROCESSES_V
APPS.OKS_ENT_TXN_GROUPS_V is referenced by following:

SchemaAPPS
Package BodyCS_CHARGE_DETAILS_PVT - show dependent code
ViewCS_CONTRACT_COVERAGES_V
PL/SQL PackageCS_EST_APPLY_CONTRACT_PKG - show dependent code
Package BodyCS_SERVICE_BILLING_ENGINE_PVT - show dependent code