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]

TABLE: OKS.OKS_BILLING_PROFILES_B

Object Details

Object Name:	OKS_BILLING_PROFILES_B
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_BILLING_PROFILES_B
Subobject Name:
Status:	VALID

This table holds Billing profile information for a customer. Billing profiles include Information about customer account, customer billing address, invoicing rule, accounting rule, billing level, billing type, billing interval, interface offset and invoiving offset. This table is populated through Billing Profile setup UI. Users can use the billing profile to overwrite any existing line level billing schedule information on the contract authoring form by selecting it in the Cascade Attributes form. Upon renewal, users can also default billing profile information onto the contract by associate a billing profile template to a customer in the Global Contract Defaults form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_BILLING_PROFILES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_BILLING_PROFILES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNED_PARTY_ID1

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique Identifier
MDA_CODE	VARCHAR2	(30)	Yes	Not being used.
OWNED_PARTY_ID1	VARCHAR2	(40)		Unique identifier for profile owning party
OWNED_PARTY_ID2	VARCHAR2	(40)		Not being used.
DEPENDENT_CUST_ACCT_ID1	VARCHAR2	(40)		Not being used.
DEPENDENT_CUST_ACCT_ID2	VARCHAR2	(40)		Not being used.
BILL_TO_ADDRESS_ID1	VARCHAR2	(40)		Bill-to address of the party.
BILL_TO_ADDRESS_ID2	VARCHAR2	(40)		Not being used.
UOM_CODE_FREQUENCY	VARCHAR2	(3)		Not being used.
TCE_CODE_FREQUENCY	VARCHAR2	(30)		Not being used.
UOM_CODE_SEC_OFFSET	VARCHAR2	(3)		Not being used.
TCE_CODE_SEC_OFFSET	VARCHAR2	(30)		Not being used.
UOM_CODE_PRI_OFFSET	VARCHAR2	(3)		Not being used.
TCE_CODE_PRI_OFFSET	VARCHAR2	(30)		Not being used.
PROFILE_NUMBER	VARCHAR2	(90)	Yes	Billing profile number. User entered value.
SUMMARISED_YN	VARCHAR2	(3)	Yes	Not being used.
REG_INVOICE_PRI_OFFSET	NUMBER	(3)		Not being used.
REG_INVOICE_SEC_OFFSET	NUMBER	(3)		Not being used.
FIRST_BILLTO_DATE	DATE			Not being used.
FIRST_INVOICE_DATE	DATE			Not being used
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.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
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
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
INVOICE_OBJECT1_ID1	VARCHAR2	(40)		Specifies the invoicing rule for Billing Profile
INVOICE_OBJECT1_ID2	VARCHAR2	(200)		Not being used.
INVOICE_JTOT_OBJECT1_CODE	VARCHAR2	(30)		JTF Object code identifying the OKX view for invoiving rule. Identifies the Source Object (Table/View/Object) that contains the invoicing rule.
ACCOUNT_OBJECT1_ID1	VARCHAR2	(40)		With ACCOUNT_OBJECT1_ID2, specifies the accounting rule for Billing Profile
ACCOUNT_OBJECT1_ID2	VARCHAR2	(200)		With ACCOUNT_OBJECT1_ID1, specifies the accounting rule for Billing Profile
ACCOUNT_JTOT_OBJECT1_CODE	VARCHAR2	(30)		JTF Object code identifying the OKX view for accounting rule. Identifies the Source Object (Table/View/Object) that contains the accounting rule.
BILLING_LEVEL	VARCHAR2	(30)		Specifies the Billing Level of the Billing Profile. Restricted to only one value 'Top Level'.
BILLING_TYPE	VARCHAR2	(30)		Billing Type. Possible values are 'ONE TIME' or 'RECURRING'
INTERVAL	VARCHAR2	(90)		Specifies Billing Interval when Billing Type is 'recurring'. Stores UOM for periods like 'Day','Year','Month' etc.
INTERFACE_OFFSET	NUMBER			Numeric values to denote Billing interface offset, specifies the offset using interval as UOM.
INVOICE_OFFSET	NUMBER			Numeric values to denote Billing invoice offset, specifies the offset using interval as UOM.

Query Text

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


SELECT ID
,      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
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      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 OKS.OKS_BILLING_PROFILES_B;

Dependencies

[top of page]

OKS.OKS_BILLING_PROFILES_B does not reference any database object

OKS.OKS_BILLING_PROFILES_B is referenced by following:

OKS: OKS_BILLING_PROFILES_B#