[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_PERSON_ACCT_V

Object Details

Object Name:	AMS_PERSON_ACCT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_PERSON_ACCT_V
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

Query Text

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

SELECT CUST_ACCOUNT_ID
,      PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      SALUTATION
,      PERSON_TITLE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      COUNTRY_NAME
,      URL
,      EMAIL_ADDRESS
,      PARTY_SITE_ID
,      PARTY_SITE_NAME
,      REGION
,      MAILSTOP
,      LANGUAGE
,      IDENTIFYING_ADDRESS_FLAG
,      ACCOUNT_NUMBER
,      ACCOUNT_REPLICATION_KEY
,      ORIG_SYSTEM_REFERENCE
,      STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      WAREHOUSE_ID
,      WH_UPDATE_DATE
,      CUSTOMER_TYPE
,      CUSTOMER_CLASS_CODE
,      PRIMARY_SALESREP_ID
,      SALES_CHANNEL_CODE
,      TAX_CODE
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      FOB_POINT
,      FREIGHT_TERM
,      SHIP_PARTIAL
,      SHIP_VIA
,      PAYMENT_TERM_ID
,      COTERMINATE_DAY_MONTH
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      ACCOUNT_LIABLE_FLAG
,      RESTRICTION_LIMIT_AMOUNT
,      CURRENT_BALANCE
,      PASSWORD_TEXT
,      HIGH_PRIORITY_INDICATOR
,      ACCOUNT_ESTABLISHED_DATE
,      ACCOUNT_TERMINATION_DATE
,      ACCOUNT_ACTIVATION_DATE
,      CREDIT_CLASSIFICATION_CODE
,      DEPARTMENT
,      MAJOR_ACCOUNT_NUMBER
,      HOTWATCH_SERVICE_FLAG
,      HOTWATCH_SVC_BAL_IND
,      HELD_BILL_EXPIRATION_DATE
,      HOLD_BILL_FLAG
,      HIGH_PRIORITY_REMARKS
,      PO_EFFECTIVE_DATE
,      PO_EXPIRATION_DATE
,      REALTIME_RATE_FLAG
,      SINGLE_USER_FLAG
,      WATCH_ACCOUNT_FLAG
,      WATCH_BALANCE_INDICATOR
,      ACCT_LIFE_CYCLE_STATUS
,      ACCOUNT_NAME
,      DEPOSIT_REFUND_METHOD
,      DORMANT_ACCOUNT_FLAG
,      NPA_NUMBER
,      PIN_NUMBER
,      SUSPENSION_DATE
,      WRITE_OFF_ADJUSTMENT_AMOUNT
,      WRITE_OFF_PAYMENT_AMOUNT
,      WRITE_OFF_AMOUNT
,      SOURCE_CODE
,      COMPETITOR_TYPE
,      COMMENTS
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      ITEM_CROSS_REF_PREF
,      SHIP_SETS_INCLUDE_LINES_FLAG
,      ARRIVALSETS_INCLUDE_LINES_FLAG
,      SCHED_DATE_PUSH_FLAG
,      INVOICE_QUANTITY_RULE
,      PRICING_EVENT
,      STATUS_UPDATE_DATE
,      AUTOPAY_FLAG
,      NOTIFY_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CUSTOMER_CATEGORY_CODE
,      CREATED_BY_NAME
,      LAST_UPDATE_LOGIN_NAME
,      LAST_UPDATED_BY_NAME
FROM APPS.AMS_PERSON_ACCT_V;

Dependencies

[top of page]

APPS

FND_TERRITORIES_TL

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

APPS.AMS_PERSON_ACCT_V is not referenced by any database object