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

VIEW: APPS.JTF_CUST_ACCOUNTS_ALL_V

Object Details
Object Name: JTF_CUST_ACCOUNTS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_CUST_ACCOUNTS_ALL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_ACCOUNT_ID NUMBER (15) Yes Customer Account Identifier.
PARTY_ID NUMBER (15) Yes A foreign key to the HZ_PARTY table.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
ACCOUNT_NUMBER VARCHAR2 (30) Yes Account Number
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
WH_UPDATE_DATE DATE

Warehouse update date when record was recorded or changed
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
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
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved For Globalization Functionality
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Unique customer identifier from foreign system
STATUS VARCHAR2 (1) Yes Customer status flag. Lookup code for CODE_STATUS
CUSTOMER_TYPE VARCHAR2 (30)
Receivables lookup code for ?CUSTOMER_TYPE? (?I? for internal customers; ?R? for 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 Entry lookup code for ?SALES_CHANNEL?
ORDER_TYPE_ID NUMBER (15)
Order type identifier
PRICE_LIST_ID NUMBER (15)
Price list identifier
CATEGORY_CODE VARCHAR2 (0)
Category code
REFERENCE_USE_FLAG VARCHAR2 (0)
Reference Use Flag
SUBCATEGORY_CODE VARCHAR2 (30)
User-definable subcategory
TAX_CODE VARCHAR2 (50)
Tax code for this customer
THIRD_PARTY_FLAG VARCHAR2 (0)
Third Party Flag
COMPETITOR_FLAG VARCHAR2 (0)
Competitor Flag
FOB_POINT VARCHAR2 (30)
he 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 Entry lookup code for ?FREIGHT_TERMS?
SHIP_PARTIAL VARCHAR2 (1)
Flag if partial shipments can be sent.
SHIP_VIA VARCHAR2 (30)
Name of shipping firm
WAREHOUSE_ID NUMBER (15)
Warehouse identifier
PAYMENT_TERM_ID NUMBER (15)
This column is not used by AR. (used by Oracle Order Entry)
TAX_HEADER_LEVEL_FLAG VARCHAR2 (1)
Tax calculation level (?Y? means Header; ?N? means Line)
TAX_ROUNDING_RULE VARCHAR2 (30)
Tax amount rounding rule
COTERMINATE_DAY_MONTH VARCHAR2 (6)
Identifies the date on which 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 PER_PEOPLE
SECONDARY_SPECIALIST_ID NUMBER (15)
This column is for the service personnel dispatching feature in Incident Tracking and is a foreign key to PER_PEOPLE
ACCOUNT_LIABLE_FLAG VARCHAR2 (1)
"Y" for Yes , "N" for No
RESTRICTION_LIMIT_AMOUNT NUMBER

An amount in the local currency that restricts the usage of this account.
CURRENT_BALANCE NUMBER

Balance on the Account
PASSWORD_TEXT VARCHAR2 (60)
Password text field
HIGH_PRIORITY_INDICATOR VARCHAR2 (1)
A user assigned flag to indicate that monitoring the balance of the account is a high priority.
ACCOUNT_ESTABLISHED_DATE DATE

Date when Account is established
ACCOUNT_TERMINATION_DATE DATE

Date when Account is Terminated
ACCOUNT_ACTIVATION_DATE DATE

Date When Account is Activated
CREDIT_CLASSIFICATION_CODE VARCHAR2 (30)
Credit Classification Code
DEPARTMENT VARCHAR2 (30)
Department
MAJOR_ACCOUNT_NUMBER VARCHAR2 (30)
Major Account Number
HOTWATCH_SERVICE_FLAG VARCHAR2 (1)
"Y" for Yes, "N " for No
HOTWATCH_SVC_BAL_IND VARCHAR2 (30)
Service Balance Indicator
HELD_BILL_EXPIRATION_DATE DATE

Held Bill Expiration Date
HOLD_BILL_FLAG VARCHAR2 (1)
Y" for Yes , "N" for No do not hold the bill.
HIGH_PRIORITY_REMARKS VARCHAR2 (80)
High Priority Remarks
PO_EFFECTIVE_DATE DATE

The date in which a purchase order is effective.
PO_EXPIRATION_DATE DATE

PO Expiration Date
REALTIME_RATE_FLAG VARCHAR2 (1)
Real time rate flag
SINGLE_USER_FLAG VARCHAR2 (1)
A value of 'Y' indicates that this account can only be used by a single user. A value of No allows for any number of users. The default is No.
WATCH_ACCOUNT_FLAG VARCHAR2 (1)
Watch Account Flag
WATCH_BALANCE_INDICATOR VARCHAR2 (1)
Watch Balance Indicator
GEO_CODE VARCHAR2 (30)
The geographic location code on the planet.
ACCT_LIFE_CYCLE_STATUS VARCHAR2 (30)
A state of the account from the point of view of the orginator of the account.
ACCOUNT_NAME VARCHAR2 (240)
A user defined name for the account.
DEPOSIT_REFUND_METHOD VARCHAR2 (20)
Refund Method
DORMANT_ACCOUNT_FLAG VARCHAR2 (1)
"Y for Yes , "N" for No
NPA_NUMBER VARCHAR2 (60)
Identifies an account with a number plan area used in telecommunications.
PIN_NUMBER NUMBER (16)
A user defined personal identification number for gaining access to this account.
SUSPENSION_DATE DATE

Date of Suspension
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

Indiates 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 (150)
A short term that identifies the type of competitor
COMMENTS VARCHAR2 (240)
Free format information about the customer
DATES_NEGATIVE_TOLERANCE NUMBER

Negative tolerance for acceptable dates
DATES_POSITIVE_TOLERANCE NUMBER

Positive tolerance for acceptable dates
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)
"Y" if lines should automatically be included in ship sets
ARRIVALSETS_INCLUDE_LINES_FLAG VARCHAR2 (1)
"Y" if lines should automatically be included in arrival sets
SCHED_DATE_PUSH_FLAG VARCHAR2 (1)
"Y" if group schedule date should automatically be pushed
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.
ACCOUNT_REPLICATION_KEY NUMBER (15)
Key used by Mobile Device Gateway products for replication.
STATUS_UPDATE_DATE DATE

Last status update date
AUTOPAY_FLAG VARCHAR2 (1)
Autopay flag
NOTIFY_FLAG VARCHAR2 (1)
Notify flag
LAST_BATCH_ID NUMBER

Last active batch
Query Text

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


SELECT CUST_ACCOUNT_ID
,      PARTY_ID
,      LAST_UPDATE_DATE
,      ACCOUNT_NUMBER
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ORIG_SYSTEM_REFERENCE
,      STATUS
,      CUSTOMER_TYPE
,      CUSTOMER_CLASS_CODE
,      PRIMARY_SALESREP_ID
,      SALES_CHANNEL_CODE
,      ORDER_TYPE_ID
,      PRICE_LIST_ID
,      CATEGORY_CODE
,      REFERENCE_USE_FLAG
,      SUBCATEGORY_CODE
,      TAX_CODE
,      THIRD_PARTY_FLAG
,      COMPETITOR_FLAG
,      FOB_POINT
,      FREIGHT_TERM
,      SHIP_PARTIAL
,      SHIP_VIA
,      WAREHOUSE_ID
,      PAYMENT_TERM_ID
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      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
,      GEO_CODE
,      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
,      ACCOUNT_REPLICATION_KEY
,      STATUS_UPDATE_DATE
,      AUTOPAY_FLAG
,      NOTIFY_FLAG
,      LAST_BATCH_ID
FROM APPS.JTF_CUST_ACCOUNTS_ALL_V;

Dependencies

[top of page]

APPS.JTF_CUST_ACCOUNTS_ALL_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
APPS.JTF_CUST_ACCOUNTS_ALL_V is referenced by following:

SchemaAPPS
ViewCSD_INCIDENTS_NON_SEC_V
ViewCSD_INCIDENTS_V
ViewCS_INCIDENTS_V
ViewCS_NEW_INCIDENTS_V
ViewCS_NEW_INCIDENTS_V_SEC
Package BodyCS_SR_FUL_PKG - show dependent code
Package BodyIEX_ROUTING_PVT - show dependent code