View: JTF_CUST_ACCOUNTS_ALL_V

Product:	JTF - CRM Foundation
Description:	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.
Implementation/DBA Data:	APPS.JTF_CUST_ACCOUNTS_ALL_V

View Text

SELECT CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY_ID PARTY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, STATUS STATUS
, CUSTOMER_TYPE CUSTOMER_TYPE
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, ORDER_TYPE_ID ORDER_TYPE_ID
, PRICE_LIST_ID PRICE_LIST_ID
, NULL CATEGORY_CODE
, NULL REFERENCE_USE_FLAG
, SUBCATEGORY_CODE SUBCATEGORY_CODE
, TAX_CODE TAX_CODE
, NULL THIRD_PARTY_FLAG
, NULL COMPETITOR_FLAG
, FOB_POINT FOB_POINT
, FREIGHT_TERM FREIGHT_TERM
, SHIP_PARTIAL SHIP_PARTIAL
, SHIP_VIA SHIP_VIA
, WAREHOUSE_ID WAREHOUSE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID
, ACCOUNT_LIABLE_FLAG ACCOUNT_LIABLE_FLAG
, RESTRICTION_LIMIT_AMOUNT RESTRICTION_LIMIT_AMOUNT
, CURRENT_BALANCE CURRENT_BALANCE
, PASSWORD_TEXT PASSWORD_TEXT
, HIGH_PRIORITY_INDICATOR HIGH_PRIORITY_INDICATOR
, ACCOUNT_ESTABLISHED_DATE ACCOUNT_ESTABLISHED_DATE
, ACCOUNT_TERMINATION_DATE ACCOUNT_TERMINATION_DATE
, ACCOUNT_ACTIVATION_DATE ACCOUNT_ACTIVATION_DATE
, CREDIT_CLASSIFICATION_CODE CREDIT_CLASSIFICATION_CODE
, DEPARTMENT DEPARTMENT
, MAJOR_ACCOUNT_NUMBER MAJOR_ACCOUNT_NUMBER
, HOTWATCH_SERVICE_FLAG HOTWATCH_SERVICE_FLAG
, HOTWATCH_SVC_BAL_IND HOTWATCH_SVC_BAL_IND
, HELD_BILL_EXPIRATION_DATE HELD_BILL_EXPIRATION_DATE
, HOLD_BILL_FLAG HOLD_BILL_FLAG
, HIGH_PRIORITY_REMARKS HIGH_PRIORITY_REMARKS
, PO_EFFECTIVE_DATE PO_EFFECTIVE_DATE
, PO_EXPIRATION_DATE PO_EXPIRATION_DATE
, REALTIME_RATE_FLAG REALTIME_RATE_FLAG
, SINGLE_USER_FLAG SINGLE_USER_FLAG
, WATCH_ACCOUNT_FLAG WATCH_ACCOUNT_FLAG
, WATCH_BALANCE_INDICATOR WATCH_BALANCE_INDICATOR
, GEO_CODE GEO_CODE
, ACCT_LIFE_CYCLE_STATUS ACCT_LIFE_CYCLE_STATUS
, ACCOUNT_NAME ACCOUNT_NAME
, DEPOSIT_REFUND_METHOD DEPOSIT_REFUND_METHOD
, DORMANT_ACCOUNT_FLAG DORMANT_ACCOUNT_FLAG
, NPA_NUMBER NPA_NUMBER
, PIN_NUMBER PIN_NUMBER
, SUSPENSION_DATE SUSPENSION_DATE
, WRITE_OFF_ADJUSTMENT_AMOUNT WRITE_OFF_ADJUSTMENT_AMOUNT
, WRITE_OFF_PAYMENT_AMOUNT WRITE_OFF_PAYMENT_AMOUNT
, WRITE_OFF_AMOUNT WRITE_OFF_AMOUNT
, SOURCE_CODE SOURCE_CODE
, COMPETITOR_TYPE COMPETITOR_TYPE
, COMMENTS COMMENTS
, DATES_NEGATIVE_TOLERANCE DATES_NEGATIVE_TOLERANCE
, DATES_POSITIVE_TOLERANCE DATES_POSITIVE_TOLERANCE
, DATE_TYPE_PREFERENCE DATE_TYPE_PREFERENCE
, OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE
, ITEM_CROSS_REF_PREF ITEM_CROSS_REF_PREF
, SHIP_SETS_INCLUDE_LINES_FLAG SHIP_SETS_INCLUDE_LINES_FLAG
, ARRIVALSETS_INCLUDE_LINES_FLAG ARRIVALSETS_INCLUDE_LINES_FLAG
, SCHED_DATE_PUSH_FLAG SCHED_DATE_PUSH_FLAG
, INVOICE_QUANTITY_RULE INVOICE_QUANTITY_RULE
, PRICING_EVENT PRICING_EVENT
, ACCOUNT_REPLICATION_KEY ACCOUNT_REPLICATION_KEY
, STATUS_UPDATE_DATE STATUS_UPDATE_DATE
, AUTOPAY_FLAG AUTOPAY_FLAG
, NOTIFY_FLAG NOTIFY_FLAG
, LAST_BATCH_ID LAST_BATCH_ID
FROM HZ_CUST_ACCOUNTS

Columns