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


VIEW: APPS.AMS_ORG_ACCT_V

Object Details
Object Name: AMS_ORG_ACCT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_ORG_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
Name Datatype Length Mandatory Comments
CUST_ACCOUNT_ID NUMBER (15) Yes Customer Account Identifier
PARTY_ID NUMBER (15) Yes Party Identifier
PARTY_NAME VARCHAR2 (360) Yes Party Name
PARTY_NUMBER VARCHAR2 (30) Yes Unique Number for Identification of the party
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
PERSON_FIRST_NAME VARCHAR2 (150)
Person First Name
PERSON_MIDDLE_NAME VARCHAR2 (60)
Middle Name
PERSON_LAST_NAME VARCHAR2 (150)
Last Name
PERSON_NAME_SUFFIX VARCHAR2 (30)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
PERSON_TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
PROVINCE VARCHAR2 (60)
Province of the Identifying address
COUNTY VARCHAR2 (60)
County of the Identifying address
COUNTRY VARCHAR2 (60)
Country of the Identifying address
COUNTRY_NAME VARCHAR2 (80) Yes Name of Country of the Identifying address
URL VARCHAR2 (2000)
Uniform resource locator
PARTY_SITE_ID NUMBER (15)
Party Site Identifier
PARTY_SITE_NAME VARCHAR2 (240)
Party Site Name
REGION VARCHAR2 (30)
Region
MAILSTOP VARCHAR2 (60)
Mail Stop
LANGUAGE VARCHAR2 (4)
Language
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (1)
Y if this is primary address
ACCOUNT_NUMBER VARCHAR2 (30) Yes Acoount Idnetifier
ACCOUNT_REPLICATION_KEY NUMBER (15)
Key used for replication in Oracle CRM applications for mobile devices
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
STATUS VARCHAR2 (1) Yes Status flag.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
WAREHOUSE_ID NUMBER (15)
Warehouse Id
WH_UPDATE_DATE DATE

Date when the record was entered or changed in a data warehouse
CUSTOMER_TYPE VARCHAR2 (30)
Receivables lookup code for the CUSTOMER_TYPE attribute. I for internal customers, R for revenue generating external customers.
CUSTOMER_CLASS_CODE VARCHAR2 (30)
Customer class indentifier
PRIMARY_SALESREP_ID NUMBER (15)
Primary sales rep identifier
SALES_CHANNEL_CODE VARCHAR2 (30)
Order Management lookup code for the SALES_CHANNEL attribute.
TAX_CODE VARCHAR2 (50)
Tax code for this customer
TAX_HEADER_LEVEL_FLAG VARCHAR2 (1)
Indicate if item is tax header or a line item. Y for records that are headers for tax purposes, N for records that are lines.
TAX_ROUNDING_RULE VARCHAR2 (30)
Tax amount rounding rule
FOB_POINT VARCHAR2 (30)
The point in a shipment at which title to the goods is transferred. Examples include, FOB delivered (the title changes hands at the point of delivery).
FREIGHT_TERM VARCHAR2 (30)
Order Management lookup code for the FREIGHT_TERMS attribute.
SHIP_PARTIAL VARCHAR2 (1)
Indicates if this customer accepts partial shipments. Y for customer accepts partial shipments, N for customer will not accept partial shipments.
SHIP_VIA VARCHAR2 (30)
The name of the preferred ship method.
PAYMENT_TERM_ID NUMBER (15)
This column is used by Oracle Order Management, not by Oracle Receivables.
COTERMINATE_DAY_MONTH VARCHAR2 (6)
Identifies the date when services ordered by the customer will end. Values for this column will take the form DD-MON.
PRIMARY_SPECIALIST_ID NUMBER (15)
This column is for the service personnel dispatching feature in Incident Tracking and is a foreign key to the PER_PEOPLE table
SECONDARY_SPECIALIST_ID NUMBER (15)
This column is for the service personnel dispatching feature in Incident Tracking and is a foreign key to the PER_PEOPLE table
ACCOUNT_LIABLE_FLAG VARCHAR2 (0)
Indicates if the account is liable for other customer accounts. Y for customers accounts that are responsible for the liabiliities of other customer accounts, N for an account that is not liable for other accounts.
RESTRICTION_LIMIT_AMOUNT NUMBER

An amount in the local currency that restricts the usage of this account.
CURRENT_BALANCE VARCHAR2 (0)
Total balance on the account
PASSWORD_TEXT VARCHAR2 (60)
Password text field
HIGH_PRIORITY_INDICATOR VARCHAR2 (1)
A user-assigned flag that indicates that monitoring the balance of the account is a high priority.
ACCOUNT_ESTABLISHED_DATE DATE

Date when the account was established
ACCOUNT_TERMINATION_DATE VARCHAR2 (0)
Date when the account was terminated
ACCOUNT_ACTIVATION_DATE VARCHAR2 (0)
Date when account was activated
CREDIT_CLASSIFICATION_CODE VARCHAR2 (30)
Credit classification code
DEPARTMENT VARCHAR2 (0)
Customer department responsible for this account
MAJOR_ACCOUNT_NUMBER VARCHAR2 (30)
Number assigned to this customer account that indicates that the account is a major account
HOTWATCH_SERVICE_FLAG VARCHAR2 (1)
Indicates if the hotwatch service is used for this account. Y for hotwatch accounts, N for accounts that are not under hotwatch
HOTWATCH_SVC_BAL_IND VARCHAR2 (30)
Service Balance Indicator
HELD_BILL_EXPIRATION_DATE DATE

Bill Expiration date
HOLD_BILL_FLAG VARCHAR2 (1)
Indicates if the bill receivable should be held or not. Y for holding the bill, N for bills receivable should not be held.
HIGH_PRIORITY_REMARKS VARCHAR2 (80)
High priority remarks
PO_EFFECTIVE_DATE DATE

The date when a purchase order is effective
PO_EXPIRATION_DATE DATE

Date when purchase order expires
REALTIME_RATE_FLAG VARCHAR2 (0)
Real time rate flag
SINGLE_USER_FLAG VARCHAR2 (1)
Indicates if this account can only be used by a single user or multiple users. Y for a customer account that can only be used by one person, N for a customer account that can be used by several people. The default is N.
WATCH_ACCOUNT_FLAG VARCHAR2 (1)
Watch account flag
WATCH_BALANCE_INDICATOR VARCHAR2 (1)
Watch balance indicator
ACCT_LIFE_CYCLE_STATUS VARCHAR2 (0)
A state of the account from the point of view of the orginator of the account.
ACCOUNT_NAME VARCHAR2 (240)
Description chosen by external party (but can be entered internally on behalf on the customer)
DEPOSIT_REFUND_METHOD VARCHAR2 (20)
Refund Method
DORMANT_ACCOUNT_FLAG VARCHAR2 (0)
Flag to indicate if account is dormant
NPA_NUMBER VARCHAR2 (60)
Identifies an account with a Number Plan Area (NPA) used in telecommunications.
PIN_NUMBER NUMBER (16)
A user-defined personal identification number (PIN) for gaining access to this account.
SUSPENSION_DATE VARCHAR2 (0)
Date when the account was suspended
WRITE_OFF_ADJUSTMENT_AMOUNT NUMBER

Indicates the portion of a write-off that is to be applied as an adjustment to the account balance.
WRITE_OFF_PAYMENT_AMOUNT NUMBER

Indicates the portion of a payment that is to be written off. The portion is stated as an amount in the local currency.
WRITE_OFF_AMOUNT NUMBER

Write-off amount in the local currency.
SOURCE_CODE VARCHAR2 (150)
Promotion that was used to make the party a customer
COMPETITOR_TYPE VARCHAR2 (0)
A short term that identifies the type of competitor
COMMENTS VARCHAR2 (240)
Free format information about the customer
DATES_NEGATIVE_TOLERANCE NUMBER

Maximum number of days prior to a date
DATES_POSITIVE_TOLERANCE NUMBER

Maximum number of days after a date
DATE_TYPE_PREFERENCE VARCHAR2 (20)
Preference for ship or arrival dates
OVER_SHIPMENT_TOLERANCE NUMBER

Percentage tolerance for over shipment
UNDER_SHIPMENT_TOLERANCE NUMBER

Percentage tolerance for under shipment
OVER_RETURN_TOLERANCE NUMBER

Percentage tolerance for over return
UNDER_RETURN_TOLERANCE NUMBER

Percentage tolerance for under return
ITEM_CROSS_REF_PREF VARCHAR2 (30)
Lookup for item cross reference preference for placing orders
SHIP_SETS_INCLUDE_LINES_FLAG VARCHAR2 (1)
Indicates if lines should automatically be included in ship sets. Y for lines included in ship sets, N for lines not included in ship sets.
ARRIVALSETS_INCLUDE_LINES_FLAG VARCHAR2 (1)
Indicates if lines include arrival sets. Y for lines included on arrival sets, N for lines not automatically included in arrival sets
SCHED_DATE_PUSH_FLAG VARCHAR2 (1)
Indicates if the group schedule date should automatically be pushed. Y for pushing the schedule dates, N for not pushing the schedule date.
INVOICE_QUANTITY_RULE VARCHAR2 (30)
Rule to indicate whether to invoice for ordered quantity or fulfilled quantity
PRICING_EVENT VARCHAR2 (30)
Event at which to price orders. For example, at entry, at shipping, or at invoicing.
STATUS_UPDATE_DATE DATE

Status Update Date
AUTOPAY_FLAG VARCHAR2 (1)
Autopay flag
NOTIFY_FLAG VARCHAR2 (0)
Notify flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Segment Column
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
customer category code
CREATED_BY_NAME NUMBER (15) Yes Who Column
LAST_UPDATE_LOGIN_NAME NUMBER (15)
Who Column
LAST_UPDATED_BY_NAME NUMBER (15) Yes Who Column
Query Text

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


SELECT CUST_ACCOUNT_ID
,      PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      EMAIL_ADDRESS
,      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
,      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_ORG_ACCT_V;

Dependencies

[top of page]

APPS.AMS_ORG_ACCT_V references the following:

SchemaAPPS
SynonymFND_TERRITORIES_TL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.AMS_ORG_ACCT_V is not referenced by any database object