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

VIEW: APPS.OKS_ENT_BILL_TYPES_V

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

View Type

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


Billing Type View For Service Contracts


[View Source]

Columns
Name Datatype Length Mandatory Comments
BILLING_TYPE_ID NUMBER
Yes Billing Type Identifier
NAME VARCHAR2 (90) Yes Name Of the Billing type
BILLING_TYPE VARCHAR2 (30) Yes Billing Type
CONTRACT_BILLING_TYPE_ID NUMBER
Yes Billing Type Identifier for service Contracts
TXN_GROUP_ID NUMBER

Transaction Group Identifier(Business process Identifier)
COVERED_AMOUNT NUMBER

Amount Covered
COVERED_PERCENT NUMBER

Percentage Covered
Query Text

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


SELECT BILLING_TYPE_ID
,      NAME
,      BILLING_TYPE
,      CONTRACT_BILLING_TYPE_ID
,      TXN_GROUP_ID
,      COVERED_AMOUNT
,      COVERED_PERCENT
FROM APPS.OKS_ENT_BILL_TYPES_V;

Dependencies

[top of page]

APPS.OKS_ENT_BILL_TYPES_V references the following:

SchemaAPPS
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKS_K_LINES_B
ViewOKX_TXN_BILLING_TYPES_V
APPS.OKS_ENT_BILL_TYPES_V is referenced by following:

SchemaAPPS
Package BodyCS_SERVICE_BILLING_ENGINE_PVT - show dependent code