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]

TABLE: AP.AP_CHECKS_ALL

Object Details

Object Name:	AP_CHECKS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_CHECKS_ALL
Subobject Name:
Status:	VALID

This tables holds data related to the payments issued to suppliers from Payments Workbench and Payments Manager(IBY) .
There is one row stored in this table for each payment issued to a supplier or refund received from a supplier. This table stores the information of supplier name, the bank account used for payment, the payment amount, payment date and other important details related to payment. Oracle Payables application stores address information for all payments. If there are changes to the supplier payment address on manual payments or Quick payments, then application maintains the new address information in this table. In case of electronic payments, the details of supplier's bank like BANK_ACCOUNT_NUM, BANK_NUM and BANK_ACCOUNT_TYPE are also maintained.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_CHECKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHECK_ID
AP_CHECKS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE
AP_CHECKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_DATE
AP_CHECKS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUTURE_PAY_DUE_DATE
AP_CHECKS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CE_BANK_ACCT_USE_ID
AP_CHECKS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_ID
AP_CHECKS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID
AP_CHECKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_NUMBER
AP_CHECKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECKRUN_NAME
AP_CHECKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TYPE_FLAG
AP_CHECKS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
AP_CHECKS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
AP_CHECKS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_SITE_ID
AP_CHECKS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECKRUN_ID
AP_CHECKS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETED_PMTS_GROUP_ID
AP_FC_PAYMENT_N1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("ACTUAL_VALUE_DATE",NVL("ANTICIPATED_VALUE_DATE",NVL("FUTURE_PAY_DUE_DATE","CHECK_DATE")))

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT	NUMBER		Yes	Indicates payment amount in payment currency.
BANK_ACCOUNT_ID	NUMBER	(15)		No longer used
BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes	The bank account name from which payment is made.
CHECK_DATE	DATE		Yes	Payment date
CHECK_ID	NUMBER	(15)	Yes	Unique internal Identifier for this record. Generated using a database sequence.
CHECK_NUMBER	NUMBER	(15)	Yes	Payment number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Indicates payment currency code in which payment is made.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(25)		Indicates the payment method.
PAYMENT_TYPE_FLAG	VARCHAR2	(25)	Yes	This flag indicates the payment type. The possible values are quick payments, manual payments, refunds etc.
ADDRESS_LINE1	VARCHAR2	(240)		First address line of payment
ADDRESS_LINE2	VARCHAR2	(240)		Second address line of payment
ADDRESS_LINE3	VARCHAR2	(240)		Third address line of payment
CHECKRUN_NAME	VARCHAR2	(255)		This is the Payment Process Request Name in the payment manager.
CHECK_FORMAT_ID	NUMBER	(15)		This corresponds to the Payment Format attached to the payment. The payment format is attached to the payment documents.
CHECK_STOCK_ID	NUMBER	(15)		Unique identifier attached to the payment document
CITY	VARCHAR2	(25)		City
COUNTRY	VARCHAR2	(25)		Country
CREATED_BY	NUMBER	(15)		Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
STATUS_LOOKUP_CODE	VARCHAR2	(25)		Indicates the current status of payment. The possible payment status can be Negotiable, Set up, Spoiled, Cleared etc
VENDOR_NAME	VARCHAR2	(240)		Supplier name
VENDOR_SITE_CODE	VARCHAR2	(15)		The Supplier site code of payment.
ZIP	VARCHAR2	(20)		State or province postal code
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Supplier's bank account number for electronic payment purposes
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Supplier's bank account type code for electronic payment purposes
BANK_NUM	VARCHAR2	(30)		Supplier's bank number for electronic payment purposes
CHECK_VOUCHER_NUM	NUMBER	(16)		No Longer Used
CLEARED_AMOUNT	NUMBER			Amount disbursed by the bank as on the cleared date. This information is also stored in Cash management
CLEARED_DATE	DATE			Date when the bank disbursed the payment. This information is also stored in Cash management.
DOC_CATEGORY_CODE	VARCHAR2	(30)		Sequential Numbering (voucher number) document category for payment
DOC_SEQUENCE_ID	NUMBER			Sequential Numbering document sequence identifier
DOC_SEQUENCE_VALUE	NUMBER			Voucher number (sequential numbering) for payment
PROVINCE	VARCHAR2	(150)		No longer used
RELEASED_AT	VARCHAR2	(18)		No longer used
RELEASED_BY	NUMBER	(15)		User that released stop payment
STATE	VARCHAR2	(150)		State
STOPPED_AT	VARCHAR2	(18)		No longer used
STOPPED_BY	NUMBER	(15)		User that recorded stop payment
VOID_DATE	DATE			Payment void date
ATTRIBUTE1	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
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
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
FUTURE_PAY_DUE_DATE	DATE			Negotiable date for future dated payment
TREASURY_PAY_DATE	DATE			No Longer Used
TREASURY_PAY_NUMBER	NUMBER	(15)		No Longer Used
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Transaction code for creating US Standard General Ledger journal entries
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		USSGL Transaction Code Descriptive Flexfield context column
WITHHOLDING_STATUS_LOOKUP_CODE	VARCHAR2	(25)		No longer used
RECONCILIATION_BATCH_ID	NUMBER	(15)		No Longer Used
CLEARED_BASE_AMOUNT	NUMBER			Payment cleared amount in functional currency
CLEARED_EXCHANGE_RATE	NUMBER			This is the exchange rate at which the payment is cleared. This is used only for foreign currency payments.
CLEARED_EXCHANGE_DATE	DATE			This is the date used for calculating the exchange rate for the payments disbursed. This is used only for foreign currency payments.
CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		This is the exchange rate type like Spot, Corporate etc taken for payment clearing. This is used only for foreign currency payments
ADDRESS_LINE4	VARCHAR2	(240)		Fourth address line of payment. Used for flexible address formatting
COUNTY	VARCHAR2	(150)		Used for flexible address formatting. Also used for matching AP and AR addresses
ADDRESS_STYLE	VARCHAR2	(30)		Used as context value in FAF descr flexs. Do not populate. Instead, join to FND_TERRITORIES where territory_code=country
ORG_ID	NUMBER	(15)		Unique internal identifier of the Operating Unit to which the payment belongs
VENDOR_ID	NUMBER	(15)		This is the unique identifier of supplier. In Cash management, these fields are used to Find Transactions by Supplier so that these transactions can be cleared.
VENDOR_SITE_ID	NUMBER	(15)		This is the unique identifier of supplier site. In Cash management, these fields are used to Find Transactions by Supplier so that these transactions can be cleared
EXCHANGE_RATE	NUMBER			Exchange rate for foreign currency payment
EXCHANGE_DATE	DATE			This is the date on which the exchange rate is effective. Applicable for foreign currency payments.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		This is the exchange rate type like Spot, Corporate etc used for foreign currency payments
BASE_AMOUNT	NUMBER			This is the Payment amount in functional currency. This is derived using the payment amount and the exchange rate
CHECKRUN_ID	NUMBER	(15)		This is the unique identifier assigned to the payment process request.
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.
CLEARED_ERROR_AMOUNT	NUMBER			This is the payment error amount calculated on clearing the payments. This is calculated in cash management.
CLEARED_CHARGES_AMOUNT	NUMBER			This is the bank charges amount calculated on clearing the payments. This is calculated in cash management.
CLEARED_ERROR_BASE_AMOUNT	NUMBER			This is the payment error amount expressed in functional currency
CLEARED_CHARGES_BASE_AMOUNT	NUMBER			This is the payment charges amount expressed in functional currency
POSITIVE_PAY_STATUS_CODE	VARCHAR2	(25)		This is the status set by and used by Positive Pay Report to select records.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
TRANSFER_PRIORITY	VARCHAR2	(25)		This indicates the priority for transfer of electronic payments. Applicable for bank charge users only. Values are Any, Express or Normal.
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		Unique internal identifier for the supplier bank account associated with payment. Foreign key to the IBY_EXT_BANK_ACCOUNTS table
STAMP_DUTY_AMT	NUMBER			Stamp duty tax amount for globalization
STAMP_DUTY_BASE_AMT	NUMBER			Stamp duty tax amount in functional currency for globalization
MRC_CLEARED_BASE_AMOUNT	VARCHAR2	(2000)		No Longer Used
MRC_CLEARED_EXCHANGE_RATE	VARCHAR2	(2000)		No Longer Used
MRC_CLEARED_EXCHANGE_DATE	VARCHAR2	(2000)		No Longer Used
MRC_CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		No Longer Used
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		No Longer Used
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		No Longer Used
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		No Longer Used
MRC_BASE_AMOUNT	VARCHAR2	(2000)		No Longer Used
MRC_CLEARED_ERROR_BASE_AMOUNT	VARCHAR2	(2000)		No Longer Used
MRC_CLEARED_CHARGES_BASE_AMT	VARCHAR2	(2000)		No Longer Used
MRC_STAMP_DUTY_BASE_AMT	VARCHAR2	(2000)		No Longer Used
MATURITY_EXCHANGE_DATE	DATE			This is the date used for identifying exchange rate on matured payments. This is usually the maturity date for the payment.
MATURITY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		This is the exchange rate type at future dated payment maturity time. This is applicable for foreign currency payments only.
MATURITY_EXCHANGE_RATE	NUMBER			This is the exchange rate used at future dated payment maturity time. This is applicable for foreign currency payments only
DESCRIPTION	VARCHAR2	(240)		This is the payment description.
ACTUAL_VALUE_DATE	DATE			Actual Value Date. For use by Cash Management
ANTICIPATED_VALUE_DATE	DATE			Anticipated Value Date. For use by Cash Management
RELEASED_DATE	DATE			Date and time user released stop payment
STOPPED_DATE	DATE			Date and time user recorded stop payment
MRC_MATURITY_EXG_DATE	VARCHAR2	(2000)		No Longer Used
MRC_MATURITY_EXG_RATE	VARCHAR2	(2000)		No Longer Used
MRC_MATURITY_EXG_RATE_TYPE	VARCHAR2	(2000)		No Longer Used
IBAN_NUMBER	VARCHAR2	(40)		International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
CE_BANK_ACCT_USE_ID	NUMBER	(15)		This is the Bank account identifier assigned by cash management to uniquely identify the bank accounts usage by various functions like Payables, Receivables etc.
PAYMENT_METHOD_CODE	VARCHAR2	(30)		This is the unique identifier assigned to the payment method selected for payment.
PARTY_ID	NUMBER	(15)		This is the party identifier maintained for the supplier. This is maintained by Trading Community Architecture.
PARTY_SITE_ID	NUMBER	(15)		This is the party site identifier maintained for the supplier. This is maintained by Trading Community Architecture.
PAYMENT_PROFILE_ID	NUMBER	(15)		This is the Unique identifier assigned to the Payment Process Profile. This is maintained by Oracle Payments.
SETTLEMENT_PRIORITY	VARCHAR2	(30)		The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY'
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
PAYMENT_DOCUMENT_ID	NUMBER	(15)		Payment document identifier
COMPLETED_PMTS_GROUP_ID	NUMBER	(15)		This is the unique identifier assigned to the completed payments. This is maintained by Oracle Payments.
PAYMENT_ID	NUMBER	(15)		This is the unique identifier assigned to the payments in Oracle Payments.
PAYMENT_INSTRUCTION_ID	NUMBER	(15)		This is the unique identifier assigned to the payment instructions in Oracle Payments.
VOID_CHECK_NUMBER	NUMBER	(15)		Voided check number
VOID_CHECK_ID	NUMBER	(15)		Voided check unique identifier
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)		Name of the supplier to whom invoice amount will be remitted
REMIT_TO_SUPPLIER_ID	NUMBER	(15)		Unique supplier identifier to whom invoice amount will be remitted
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)		Name of the supplier site to whom invoice amount will be remitted
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)		Unique supplier site identifier to whom invoice amount will be remitted
RELATIONSHIP_ID	NUMBER	(15)		Unique identifier to third party relationships of a supplier with another supplier. This column will be populated if the payment is made to the third party.
PAYCARD_AUTHORIZATION_NUMBER	VARCHAR2	(30)		This is the authorization number captured for the payments made using payment card.
PAYCARD_REFERENCE_ID	NUMBER	(15)		Unique identifier for the payment card used for the payment.

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
FROM AP.AP_CHECKS_ALL;

Dependencies

[top of page]

AP.AP_CHECKS_ALL does not reference any database object

AP.AP_CHECKS_ALL is referenced by following:

APPS: AP_CHECKS; AP_CHECKS_ALL