eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKS_BILLING_PROFILES_V

Object Details

Object Name:	OKS_BILLING_PROFILES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_BILLING_PROFILES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Auto-generated by Headstart Utilities
ID	NUMBER		Yes	Primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SFWT_FLAG	VARCHAR2	(3)	Yes	Indicates a value was changed in another language. Not fully implemented in 11i.
MDA_CODE	VARCHAR2	(30)	Yes	Foreign key to FND_LOOKUP_VALUES.
OWNED_PARTY_ID1	VARCHAR2	(40)		Owned party ID.
OWNED_PARTY_ID2	VARCHAR2	(40)		Owned Party ID.
DEPENDENT_CUST_ACCT_ID1	VARCHAR2	(40)		Dependent Customer account ID.
DEPENDENT_CUST_ACCT_ID2	VARCHAR2	(40)		Dependent Customer Account ID.
BILL_TO_ADDRESS_ID1	VARCHAR2	(40)		Bill-to address ID.
BILL_TO_ADDRESS_ID2	VARCHAR2	(40)		Bill-to address ID.
UOM_CODE_FREQUENCY	VARCHAR2	(3)		Unit of measure code frequency.
TCE_CODE_FREQUENCY	VARCHAR2	(30)		Time code frequency.
UOM_CODE_SEC_OFFSET	VARCHAR2	(3)		Unit of measure code frequency.
TCE_CODE_SEC_OFFSET	VARCHAR2	(30)		Time code frequency.
UOM_CODE_PRI_OFFSET	VARCHAR2	(3)		Unit of measure code frequency.
TCE_CODE_PRI_OFFSET	VARCHAR2	(30)		Time code frequency.
PROFILE_NUMBER	VARCHAR2	(90)	Yes	Billing profile number.
SUMMARISED_YN	VARCHAR2	(3)	Yes	Yes/No field.
REG_INVOICE_PRI_OFFSET	NUMBER	(3)		Invoice primary offset.
REG_INVOICE_SEC_OFFSET	NUMBER	(3)		Invoice secondary offset.
FIRST_BILLTO_DATE	DATE			First bill-to date.
FIRST_INVOICE_DATE	DATE			First invoice date.
MESSAGE	VARCHAR2	(720)		Billing profile message column.
DESCRIPTION	VARCHAR2	(1995)	Yes	User entered free format text description.
INSTRUCTIONS	VARCHAR2	(1995)		User defined special instructions.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
INVOICE_OBJECT1_ID1	VARCHAR2	(40)		Invoicing rule object1 id1
INVOICE_OBJECT1_ID2	VARCHAR2	(200)		Invoicing rule object1 id2.
INVOICE_JTOT_OBJECT1_CODE	VARCHAR2	(30)		Invoicing JTF object code
ACCOUNT_OBJECT1_ID1	VARCHAR2	(40)		Accounting rule object1 id1.
ACCOUNT_OBJECT1_ID2	VARCHAR2	(200)		Object1 id2 of acounting rule.
ACCOUNT_JTOT_OBJECT1_CODE	VARCHAR2	(30)		JTF object code of the accounting rule.
BILLING_LEVEL	VARCHAR2	(30)		Billing level code.
BILLING_TYPE	VARCHAR2	(30)		Billing Type.
INTERVAL	VARCHAR2	(90)		Interval (one time, recurring)
INTERFACE_OFFSET	NUMBER			Interface offset.
INVOICE_OFFSET	NUMBER			Invoice offset.

Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      MDA_CODE
,      OWNED_PARTY_ID1
,      OWNED_PARTY_ID2
,      DEPENDENT_CUST_ACCT_ID1
,      DEPENDENT_CUST_ACCT_ID2
,      BILL_TO_ADDRESS_ID1
,      BILL_TO_ADDRESS_ID2
,      UOM_CODE_FREQUENCY
,      TCE_CODE_FREQUENCY
,      UOM_CODE_SEC_OFFSET
,      TCE_CODE_SEC_OFFSET
,      UOM_CODE_PRI_OFFSET
,      TCE_CODE_PRI_OFFSET
,      PROFILE_NUMBER
,      SUMMARISED_YN
,      REG_INVOICE_PRI_OFFSET
,      REG_INVOICE_SEC_OFFSET
,      FIRST_BILLTO_DATE
,      FIRST_INVOICE_DATE
,      MESSAGE
,      DESCRIPTION
,      INSTRUCTIONS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INVOICE_OBJECT1_ID1
,      INVOICE_OBJECT1_ID2
,      INVOICE_JTOT_OBJECT1_CODE
,      ACCOUNT_OBJECT1_ID1
,      ACCOUNT_OBJECT1_ID2
,      ACCOUNT_JTOT_OBJECT1_CODE
,      BILLING_LEVEL
,      BILLING_TYPE
,      INTERVAL
,      INTERFACE_OFFSET
,      INVOICE_OFFSET
FROM APPS.OKS_BILLING_PROFILES_V;

Dependencies

[top of page]

APPS.OKS_BILLING_PROFILES_V references the following:

APPS: OKS_BILLING_PROFILES_B; OKS_BILLING_PROFILES_TL

APPS.OKS_BILLING_PROFILES_V is referenced by following:

APPS: OE_ID_TO_VALUE - show dependent code; OE_VALIDATE - show dependent code; OE_VALUE_TO_ID - show dependent code; OKS_BILLING_PROFILES_PUB - show dependent code; OKS_BILLING_PROFILES_PVT - show dependent code; OKS_BILL_REC_PUB - show dependent code; OKS_BILL_SCH - show dependent code; OKS_BPE_PVT - show dependent code; OKS_BPE_PVT - show dependent code; OKS_ENTITLEMENTS_WEB - show dependent code; OKS_MASSCHANGE_PVT - show dependent code; OKS_RENEW_CONTRACT_PVT - show dependent code