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.

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

VIEW: AP.AP_CHECKS_ALL#

Object Details

Object Name:	AP_CHECKS_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
AMOUNT	NUMBER		Yes
BANK_ACCOUNT_ID	NUMBER	(15)
BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes
CHECK_DATE	DATE		Yes
CHECK_ID	NUMBER	(15)	Yes
CHECK_NUMBER	NUMBER	(15)	Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(25)
PAYMENT_TYPE_FLAG	VARCHAR2	(25)	Yes
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
CHECKRUN_NAME	VARCHAR2	(255)
CHECK_FORMAT_ID	NUMBER	(15)
CHECK_STOCK_ID	NUMBER	(15)
CITY	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
STATUS_LOOKUP_CODE	VARCHAR2	(25)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_SITE_CODE	VARCHAR2	(15)
ZIP	VARCHAR2	(60)
BANK_ACCOUNT_NUM	VARCHAR2	(30)
BANK_ACCOUNT_TYPE	VARCHAR2	(25)
BANK_NUM	VARCHAR2	(30)
CHECK_VOUCHER_NUM	NUMBER	(16)
CLEARED_AMOUNT	NUMBER
CLEARED_DATE	DATE
DOC_CATEGORY_CODE	VARCHAR2	(30)
DOC_SEQUENCE_ID	NUMBER
DOC_SEQUENCE_VALUE	NUMBER
PROVINCE	VARCHAR2	(150)
RELEASED_AT	VARCHAR2	(18)
RELEASED_BY	NUMBER	(15)
STATE	VARCHAR2	(150)
STOPPED_AT	VARCHAR2	(18)
STOPPED_BY	NUMBER	(15)
VOID_DATE	DATE
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
FUTURE_PAY_DUE_DATE	DATE
TREASURY_PAY_DATE	DATE
TREASURY_PAY_NUMBER	NUMBER	(15)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
WITHHOLDING_STATUS_LOOKUP_CODE	VARCHAR2	(25)
RECONCILIATION_BATCH_ID	NUMBER	(15)
CLEARED_BASE_AMOUNT	NUMBER
CLEARED_EXCHANGE_RATE	NUMBER
CLEARED_EXCHANGE_DATE	DATE
CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
ADDRESS_LINE4	VARCHAR2	(240)
COUNTY	VARCHAR2	(150)
ADDRESS_STYLE	VARCHAR2	(30)
ORG_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
VENDOR_SITE_ID	NUMBER	(15)
EXCHANGE_RATE	NUMBER
EXCHANGE_DATE	DATE
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
BASE_AMOUNT	NUMBER
CHECKRUN_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
CLEARED_ERROR_AMOUNT	NUMBER
CLEARED_CHARGES_AMOUNT	NUMBER
CLEARED_ERROR_BASE_AMOUNT	NUMBER
CLEARED_CHARGES_BASE_AMOUNT	NUMBER
POSITIVE_PAY_STATUS_CODE	VARCHAR2	(25)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
TRANSFER_PRIORITY	VARCHAR2	(25)
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
STAMP_DUTY_AMT	NUMBER
STAMP_DUTY_BASE_AMT	NUMBER
MRC_CLEARED_BASE_AMOUNT	VARCHAR2	(2000)
MRC_CLEARED_EXCHANGE_RATE	VARCHAR2	(2000)
MRC_CLEARED_EXCHANGE_DATE	VARCHAR2	(2000)
MRC_CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)
MRC_EXCHANGE_RATE	VARCHAR2	(2000)
MRC_EXCHANGE_DATE	VARCHAR2	(2000)
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)
MRC_BASE_AMOUNT	VARCHAR2	(2000)
MRC_CLEARED_ERROR_BASE_AMOUNT	VARCHAR2	(2000)
MRC_CLEARED_CHARGES_BASE_AMT	VARCHAR2	(2000)
MRC_STAMP_DUTY_BASE_AMT	VARCHAR2	(2000)
MATURITY_EXCHANGE_DATE	DATE
MATURITY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
MATURITY_EXCHANGE_RATE	NUMBER
DESCRIPTION	VARCHAR2	(240)
ACTUAL_VALUE_DATE	DATE
ANTICIPATED_VALUE_DATE	DATE
RELEASED_DATE	DATE
STOPPED_DATE	DATE
MRC_MATURITY_EXG_DATE	VARCHAR2	(2000)
MRC_MATURITY_EXG_RATE	VARCHAR2	(2000)
MRC_MATURITY_EXG_RATE_TYPE	VARCHAR2	(2000)
IBAN_NUMBER	VARCHAR2	(40)
CE_BANK_ACCT_USE_ID	NUMBER	(15)
PAYMENT_METHOD_CODE	VARCHAR2	(30)
PARTY_ID	NUMBER	(15)
PARTY_SITE_ID	NUMBER	(15)
PAYMENT_PROFILE_ID	NUMBER	(15)
SETTLEMENT_PRIORITY	VARCHAR2	(30)
BANK_CHARGE_BEARER	VARCHAR2	(30)
LEGAL_ENTITY_ID	NUMBER	(15)
PAYMENT_DOCUMENT_ID	NUMBER	(15)
COMPLETED_PMTS_GROUP_ID	NUMBER	(15)
PAYMENT_ID	NUMBER	(15)
PAYMENT_INSTRUCTION_ID	NUMBER	(15)
VOID_CHECK_NUMBER	NUMBER	(15)
VOID_CHECK_ID	NUMBER	(15)
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)
REMIT_TO_SUPPLIER_ID	NUMBER	(15)
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)
RELATIONSHIP_ID	NUMBER	(15)
PAYCARD_AUTHORIZATION_NUMBER	VARCHAR2	(30)
PAYCARD_REFERENCE_ID	NUMBER	(15)
ACKNOWLEDGED_FLAG	VARCHAR2	(1)

Query Text

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


SELECT AMOUNT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      CHECK_DATE
,      CHECK_ID
,      CHECK_NUMBER
,      CURRENCY_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PAYMENT_METHOD_LOOKUP_CODE
,      PAYMENT_TYPE_FLAG
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CHECKRUN_NAME
,      CHECK_FORMAT_ID
,      CHECK_STOCK_ID
,      CITY
,      COUNTRY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      STATUS_LOOKUP_CODE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ZIP
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_TYPE
,      BANK_NUM
,      CHECK_VOUCHER_NUM
,      CLEARED_AMOUNT
,      CLEARED_DATE
,      DOC_CATEGORY_CODE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PROVINCE
,      RELEASED_AT
,      RELEASED_BY
,      STATE
,      STOPPED_AT
,      STOPPED_BY
,      VOID_DATE
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      FUTURE_PAY_DUE_DATE
,      TREASURY_PAY_DATE
,      TREASURY_PAY_NUMBER
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      RECONCILIATION_BATCH_ID
,      CLEARED_BASE_AMOUNT
,      CLEARED_EXCHANGE_RATE
,      CLEARED_EXCHANGE_DATE
,      CLEARED_EXCHANGE_RATE_TYPE
,      ADDRESS_LINE4
,      COUNTY
,      ADDRESS_STYLE
,      ORG_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE_TYPE
,      BASE_AMOUNT
,      CHECKRUN_ID
,      REQUEST_ID
,      CLEARED_ERROR_AMOUNT
,      CLEARED_CHARGES_AMOUNT
,      CLEARED_ERROR_BASE_AMOUNT
,      CLEARED_CHARGES_BASE_AMOUNT
,      POSITIVE_PAY_STATUS_CODE
,      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
,      TRANSFER_PRIORITY
,      EXTERNAL_BANK_ACCOUNT_ID
,      STAMP_DUTY_AMT
,      STAMP_DUTY_BASE_AMT
,      MRC_CLEARED_BASE_AMOUNT
,      MRC_CLEARED_EXCHANGE_RATE
,      MRC_CLEARED_EXCHANGE_DATE
,      MRC_CLEARED_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_BASE_AMOUNT
,      MRC_CLEARED_ERROR_BASE_AMOUNT
,      MRC_CLEARED_CHARGES_BASE_AMT
,      MRC_STAMP_DUTY_BASE_AMT
,      MATURITY_EXCHANGE_DATE
,      MATURITY_EXCHANGE_RATE_TYPE
,      MATURITY_EXCHANGE_RATE
,      DESCRIPTION
,      ACTUAL_VALUE_DATE
,      ANTICIPATED_VALUE_DATE
,      RELEASED_DATE
,      STOPPED_DATE
,      MRC_MATURITY_EXG_DATE
,      MRC_MATURITY_EXG_RATE
,      MRC_MATURITY_EXG_RATE_TYPE
,      IBAN_NUMBER
,      CE_BANK_ACCT_USE_ID
,      PAYMENT_METHOD_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      PAYMENT_PROFILE_ID
,      SETTLEMENT_PRIORITY
,      BANK_CHARGE_BEARER
,      LEGAL_ENTITY_ID
,      PAYMENT_DOCUMENT_ID
,      COMPLETED_PMTS_GROUP_ID
,      PAYMENT_ID
,      PAYMENT_INSTRUCTION_ID
,      VOID_CHECK_NUMBER
,      VOID_CHECK_ID
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
,      PAYCARD_AUTHORIZATION_NUMBER
,      PAYCARD_REFERENCE_ID
,      ACKNOWLEDGED_FLAG
FROM AP.AP_CHECKS_ALL#;

Dependencies

[top of page]

AP.AP_CHECKS_ALL# references the following:

AP: AP_CHECKS_ALL

AP.AP_CHECKS_ALL# is referenced by following:

APPS: AP_CHECKS; AP_CHECKS_ALL