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

VIEW: APPS.OKL_LA_VENDOR_BILLING_UV

Object Details
Object Name: OKL_LA_VENDOR_BILLING_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_VENDOR_BILLING_UV
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
CHR_ID NUMBER
Yes Contract header identifier
RGP_ID NUMBER
Yes Rule group identifier
CPL_ID NUMBER
Yes Party role record identifier
CUST_RULE_ID NUMBER
Yes Customer rule identifier
CUST_ID VARCHAR2 (40)
Customer(Party) identifier
CUST_NAME VARCHAR2 (360)
Party name
CUST_ACCT_ID NUMBER (15)
Customer account identifier
CUST_ACCOUNT_NUMBER VARCHAR2 (30)
Customer account number
CUST_ACCOUNT_NAME VARCHAR2 (240)
Customer account name
BILL_TO_SITE_USE_ID NUMBER (15)
Bill to site use identifier
BILL_TO_SITE_USE_NAME VARCHAR2 (40)
Bill to site use name
Query Text

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


SELECT CHR_ID
,      RGP_ID
,      CPL_ID
,      CUST_RULE_ID
,      CUST_ID
,      CUST_NAME
,      CUST_ACCT_ID
,      CUST_ACCOUNT_NUMBER
,      CUST_ACCOUNT_NAME
,      BILL_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_NAME
FROM APPS.OKL_LA_VENDOR_BILLING_UV;

Dependencies

[top of page]

APPS.OKL_LA_VENDOR_BILLING_UV references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymOKC_K_HEADERS_B
SynonymOKC_K_PARTY_ROLES_B
SynonymOKC_RG_PARTY_ROLES
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B

APPS.OKL_LA_VENDOR_BILLING_UV is not referenced by any database object