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: ViewOKS.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:

SchemaAPPS
SynonymOKS_BILLING_PROFILES_B
SynonymOKS_BILLING_PROFILES_TL
APPS.OKS_BILLING_PROFILES_V is referenced by following:

SchemaAPPS
Package BodyOKS_BILLING_PROFILES_PUB - show dependent code
Package BodyOKS_BILLING_PROFILES_PVT - show dependent code
Package BodyOKS_BILL_REC_PUB - show dependent code
PL/SQL PackageOKS_BPE_PVT - show dependent code
Package BodyOKS_BPE_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_MASSCHANGE_PVT - show dependent code