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

VIEW: APPS.JTF_CUST_ACCOUNTS_V

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

View Type

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


JTF_CUST_ACCOUNTS_V retrieves information about customer relationships. If a party becomes a customer, information about the customer account is shown.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
System generated identifier
CUST_ACCOUNT_ID NUMBER (15) Yes Customer Account Identifier
ORG_ID VARCHAR2 (0)
Organization 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
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
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)
User-definable category
REFERENCE_USE_FLAG VARCHAR2 (0)
Reference use indicator
SUBCATEGORY_CODE VARCHAR2 (30)
User-definable subcategory
TAX_CODE VARCHAR2 (50)
Tax code for this customer
THIRD_PARTY_FLAG VARCHAR2 (0)
Third Party Indicator
COMPETITOR_FLAG VARCHAR2 (0)
Competitor
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)
Freight Term
SHIP_PARTIAL VARCHAR2 (1)
Partial ship indicator
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)
Secondary Specialist
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 whe'Date when Account is Terminated
ACCOUNT_ACTIVATION_DATE DATE

Account Activation Date
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)
NPA Number
PIN_NUMBER NUMBER (16)
Pin Number
SUSPENSION_DATE DATE

Suspension Date
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)
Comments
DATES_NEGATIVE_TOLERANCE NUMBER

Dates Negative Tolerance
DATES_POSITIVE_TOLERANCE NUMBER

Dates Positive Tolerance
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)
Indicotor for Ship Set Lines
ARRIVALSETS_INCLUDE_LINES_FLAG VARCHAR2 (1)
Arrival Sets for including Lines
SCHED_DATE_PUSH_FLAG VARCHAR2 (1)
Indicator for Schedule Date
INVOICE_QUANTITY_RULE VARCHAR2 (30)
Invoice Quantity Flag
PRICING_EVENT VARCHAR2 (30)
Pricing Event
ACCOUNT_REPLICATION_KEY NUMBER (15)
Key used by Mobile Device Gateway products for replication
Query Text

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


SELECT ROW_ID
,      CUST_ACCOUNT_ID
,      ORG_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
FROM APPS.JTF_CUST_ACCOUNTS_V;

Dependencies

[top of page]

APPS.JTF_CUST_ACCOUNTS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS

APPS.JTF_CUST_ACCOUNTS_V is not referenced by any database object