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

VIEW: APPS.OP_CUST_ASC_VW1

Object Details
Object Name: OP_CUST_ASC_VW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.OP_CUST_ASC_VW1
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_ID NUMBER (15) Yes
ASSOC_TYPE NUMBER (5) Yes
ASSOCCUST_ID NUMBER (15) Yes
ASSOCCUST_NO VARCHAR2 (4000)

ASSOCCUST_NAME VARCHAR2 (40)

DELETE_MARK NUMBER (5) Yes
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
Query Text

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


SELECT CUST_ID
,      ASSOC_TYPE
,      ASSOCCUST_ID
,      ASSOCCUST_NO
,      ASSOCCUST_NAME
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
FROM APPS.OP_CUST_ASC_VW1;

Dependencies

[top of page]

APPS.OP_CUST_ASC_VW1 references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymOP_CUST_ASC
SynonymOP_CUST_MST

APPS.OP_CUST_ASC_VW1 is not referenced by any database object