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

VIEW: AMS.AMS_PARTY_MARKET_SEGMENTS#

Object Details
Object Name: AMS_PARTY_MARKET_SEGMENTS#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AMS_PARTY_MARKET_SEGMENT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
MARKET_SEGMENT_ID NUMBER
Yes
MARKET_SEGMENT_FLAG VARCHAR2 (1) Yes
PARTY_ID NUMBER
Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ORG_ID NUMBER (32)
SECURITY_GROUP_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

TERRITORY_ID NUMBER

MARKET_QUALIFIER_TYPE VARCHAR2 (15)
MARKET_QUALIFIER_REFERENCE NUMBER

CUST_ACCOUNT_ID NUMBER

CUST_ACCT_SITE_ID NUMBER

SITE_USE_CODE VARCHAR2 (30)
BILL_TO_SITE_USE_ID NUMBER

ROLLUP_PARTY_ID NUMBER

SITE_USE_ID NUMBER

Query Text

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


SELECT AMS_PARTY_MARKET_SEGMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      MARKET_SEGMENT_ID
,      MARKET_SEGMENT_FLAG
,      PARTY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORG_ID
,      SECURITY_GROUP_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TERRITORY_ID
,      MARKET_QUALIFIER_TYPE
,      MARKET_QUALIFIER_REFERENCE
,      CUST_ACCOUNT_ID
,      CUST_ACCT_SITE_ID
,      SITE_USE_CODE
,      BILL_TO_SITE_USE_ID
,      ROLLUP_PARTY_ID
,      SITE_USE_ID
FROM AMS.AMS_PARTY_MARKET_SEGMENTS#;

Dependencies

[top of page]

AMS.AMS_PARTY_MARKET_SEGMENTS# references the following:

SchemaAMS
TableAMS_PARTY_MARKET_SEGMENTS
AMS.AMS_PARTY_MARKET_SEGMENTS# is referenced by following:

SchemaAPPS
SynonymAMS_PARTY_MARKET_SEGMENTS