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


TABLE: OSM.AS_CUST_PROFILES

Object Details
Object Name: AS_CUST_PROFILES
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_CUST_PROFILES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER
Yes
ADDRESS_ID NUMBER
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
Query Text

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


SELECT CUSTOMER_ID
,      ADDRESS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OSM.AS_CUST_PROFILES;

Dependencies

[top of page]

OSM.AS_CUST_PROFILES does not reference any database object

OSM.AS_CUST_PROFILES is referenced by following:

SchemaAPPS
SynonymAS_CUST_PROFILES