View: AMS_P_ACCT_V

Product:	AMS - Marketing
Description:	This view returns all entries from the HZ_CUST_ACCOUNTS_ALL table. Used for list generation only.
Implementation/DBA Data:	APPS.AMS_P_ACCT_V

View Text

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

Columns