eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: AP.AP_CARD_PROFILES_ALL#

Source

View Text - Preformatted


select PROFILE_ID PROFILE_ID, PROFILE_NAME PROFILE_NAME, DESCRIPTION DESCRIPTION, CARD_PROGRAM_ID CARD_PROGRAM_ID, MGR_APPROVAL_LOOKUP_CODE MGR_APPROVAL_LOOKUP_CODE, EMP_NOTIFICATION_LOOKUP_CODE EMP_NOTIFICATION_LOOKUP_CODE, DIRECT_ACCT_ENTRY_FLAG DIRECT_ACCT_ENTRY_FLAG, BUILD_ACCT_FROM_CODE_FLAG BUILD_ACCT_FROM_CODE_FLAG, ADMIN_EMPLOYEE_ID ADMIN_EMPLOYEE_ID, CARD_GL_SET_ID CARD_GL_SET_ID, ALLOW_PERSONAL_STATUS_FLAG ALLOW_PERSONAL_STATUS_FLAG, MGR_APPROVAL_REQUIRED_FLAG MGR_APPROVAL_REQUIRED_FLAG, EXCEPTION_CLEARING_CCID EXCEPTION_CLEARING_CCID, DEFAULT_ACCT_TEMPLATE DEFAULT_ACCT_TEMPLATE, ORG_ID ORG_ID, INACTIVE_DATE INACTIVE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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 from "AP"."AP_CARD_PROFILES_ALL"

View Text - HTML Formatted

SELECT PROFILE_ID PROFILE_ID
, PROFILE_NAME PROFILE_NAME
, DESCRIPTION DESCRIPTION
, CARD_PROGRAM_ID CARD_PROGRAM_ID
, MGR_APPROVAL_LOOKUP_CODE MGR_APPROVAL_LOOKUP_CODE
, EMP_NOTIFICATION_LOOKUP_CODE EMP_NOTIFICATION_LOOKUP_CODE
, DIRECT_ACCT_ENTRY_FLAG DIRECT_ACCT_ENTRY_FLAG
, BUILD_ACCT_FROM_CODE_FLAG BUILD_ACCT_FROM_CODE_FLAG
, ADMIN_EMPLOYEE_ID ADMIN_EMPLOYEE_ID
, CARD_GL_SET_ID CARD_GL_SET_ID
, ALLOW_PERSONAL_STATUS_FLAG ALLOW_PERSONAL_STATUS_FLAG
, MGR_APPROVAL_REQUIRED_FLAG MGR_APPROVAL_REQUIRED_FLAG
, EXCEPTION_CLEARING_CCID EXCEPTION_CLEARING_CCID
, DEFAULT_ACCT_TEMPLATE DEFAULT_ACCT_TEMPLATE
, ORG_ID ORG_ID
, INACTIVE_DATE INACTIVE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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
FROM "AP"."AP_CARD_PROFILES_ALL"