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_SELECTED_INVOICES_ALL

Object Details

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

AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS.
Information from this table appears in the Modify
Payment Batch window.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_SELECTED_INVOICES_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	INVOICE_ID PAYMENT_NUM
AP_SELECTED_INVOICES_N2	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PRINT_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_N3	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PAY_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_N4	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	ORIGINAL_INVOICE_ID ORIGINAL_PAYMENT_NUM
AP_SELECTED_INVOICES_N5	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	CHECKRUN_NAME
AP_SELECTED_INVOICES_N6	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	VENDOR_SITE_ID
AP_SELECTED_INVOICES_N7	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	CHECKRUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHECKRUN_NAME	VARCHAR2	(255)	Yes	Payment Process Request Name
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
PAYMENT_NUM	NUMBER	(15)	Yes	Payment number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SET_OF_BOOKS_ID	NUMBER	(15)		Set of books identifier
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VENDOR_ID	NUMBER	(15)		Supplier identifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier
VENDOR_NUM	VARCHAR2	(30)		Supplier number
VENDOR_NAME	VARCHAR2	(240)		Supplier name
VENDOR_SITE_CODE	VARCHAR2	(15)		Name of supplier site
CUSTOMER_NUM	VARCHAR2	(25)		Customer number supplier uses for your company
ADDRESS_LINE1	VARCHAR2	(240)		First line of supplier site street address
ADDRESS_LINE2	VARCHAR2	(240)		Second line of supplier site street address
ADDRESS_LINE3	VARCHAR2	(240)		Third line of supplier site street address
CITY	VARCHAR2	(25)		City of supplier site address
STATE	VARCHAR2	(150)		State of supplier site address
ZIP	VARCHAR2	(20)		Zip of supplier site address
PROVINCE	VARCHAR2	(150)		Province of supplier site address
COUNTRY	VARCHAR2	(25)		Country of supplier site address
WITHHOLDING_STATUS_LOOKUP_CODE	VARCHAR2	(25)		(Not currently used) Status that indicates if taxes should be withheld from supplier invoice payments
ATTENTION_AR_FLAG	VARCHAR2	(1)		Flag that indicates if legend Attention Accounts Receivable will appear on payments (Y or N)
INVOICE_NUM	VARCHAR2	(50)		Invoice number
INVOICE_DATE	DATE			Invoice date
VOUCHER_NUM	VARCHAR2	(50)		Voucher number
INVOICE_AMOUNT	NUMBER			Invoice amount
AMOUNT_PAID	NUMBER			Amount of invoice already paid
DISCOUNT_AMOUNT_TAKEN	NUMBER			Discount amount previously taken
AP_CCID	NUMBER	(15)		No longer used
DUE_DATE	DATE			Due date
DISCOUNT_DATE	DATE			Discount date
INVOICE_DESCRIPTION	VARCHAR2	(50)		Invoice description
PAYMENT_PRIORITY	NUMBER	(2)		Number representing payment priority of a scheduled payment (1 to 99)
AMOUNT_REMAINING	NUMBER			Invoice amount remaining for payment
DISCOUNT_AMOUNT_REMAINING	NUMBER			Amount available for discount on invoice amount remaining for payment
PAYMENT_AMOUNT	NUMBER			Amount to pay for invoice in payment batch
DISCOUNT_AMOUNT	NUMBER			Discount amount taken on invoice in payment batch
SEQUENCE_NUM	NUMBER	(15)		Order in which Oracle Payables pays supplier invoices
OK_TO_PAY_FLAG	VARCHAR2	(1)		Flag that indicates if invoices can be paid in a payment batch (Y or N)
DONT_PAY_REASON_CODE	VARCHAR2	(25)		Reason that OK_TO_PAY_FLAG is N
ALWAYS_TAKE_DISCOUNT_FLAG	VARCHAR2	(1)		Flag that indicates if discount taken regardless of when payment is made (Y or N)
AMOUNT_MODIFIED_FLAG	VARCHAR2	(1)		Flag that indicates if selected amount has been modified (Y or N)
CHECK_NUMBER	NUMBER	(15)		Payment number
INVOICE_EXCHANGE_RATE	NUMBER			Foreign currency exchange rate used for an invoice
PAYMENT_CROSS_RATE	NUMBER			If invoice currency and payment currency are associated fixed-rate currencies, this is the fixed-rate. Otherwise the value is 1
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Type of bank account
ORIGINAL_INVOICE_ID	VARCHAR2	(30)		Original invoice identifier, used for mapping an interest invoice back to invoice that it is based on in accordance with the terms of the Prompt Payment Act
ORIGINAL_PAYMENT_NUM	NUMBER	(15)		Original payment number used for mapping an interest invoice back to invoice that it is based on in accordance with the terms of the Prompt Payment Act
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
ATTRIBUTE1	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
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
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
BANK_NUM	VARCHAR2	(25)		Bank number
FUTURE_PAY_DUE_DATE	DATE			No longer used
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)		Flag that indicates invoice must be paid on separate payment document
PROPOSED_PAYMENT_AMOUNT	NUMBER			Payment amount for invoice in payment batch/Credit amount that will be applied to supplier's invoices in payment batch
PAY_SELECTED_CHECK_ID	NUMBER	(15)		Identifier for negotiable check created for payment batch
PRINT_SELECTED_CHECK_ID	NUMBER	(15)		Identifier for check on which invoice printed (same as PAY_SELECTED_CHECK_ID, except for overflow documents)
ORG_ID	NUMBER	(15)		Organization identifier
WITHHOLDING_AMOUNT	NUMBER			Amount withheld from an invoice
INVOICE_PAYMENT_ID	NUMBER	(15)		Invoice payment identifier for an invoice payment in a payment batch
DONT_PAY_DESCRIPTION	VARCHAR2	(255)		Reason that an invoice cannot be paid
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)		Transfer priority
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		External bank account identifier
ADDRESS_LINE4	VARCHAR2	(240)		Fourth line of supplier site street address
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.
CHECKRUN_ID	NUMBER	(15)		Payment Process Request Identifier
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Identifier
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)		Payment Currency Code
PAYMENT_GROUPING_NUMBER	NUMBER	(15)		Payment Grouping Number
PAYMENT_EXCHANGE_RATE	NUMBER			Exchange rate for a foreign currency payment
PAYMENT_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for a foreign currency payment
PAYMENT_EXCHANGE_DATE	DATE			Date for which exchange rate is obtained from daily rates table
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)		Name of the third party payee
REMIT_TO_SUPPLIER_ID	NUMBER	(15)		ID of the third party payee
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)		Site code of the third party payee
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)		Site id of the third party payee

Query Text

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


SELECT CHECKRUN_NAME
,      INVOICE_ID
,      PAYMENT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      CUSTOMER_NUM
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      ATTENTION_AR_FLAG
,      INVOICE_NUM
,      INVOICE_DATE
,      VOUCHER_NUM
,      INVOICE_AMOUNT
,      AMOUNT_PAID
,      DISCOUNT_AMOUNT_TAKEN
,      AP_CCID
,      DUE_DATE
,      DISCOUNT_DATE
,      INVOICE_DESCRIPTION
,      PAYMENT_PRIORITY
,      AMOUNT_REMAINING
,      DISCOUNT_AMOUNT_REMAINING
,      PAYMENT_AMOUNT
,      DISCOUNT_AMOUNT
,      SEQUENCE_NUM
,      OK_TO_PAY_FLAG
,      DONT_PAY_REASON_CODE
,      ALWAYS_TAKE_DISCOUNT_FLAG
,      AMOUNT_MODIFIED_FLAG
,      CHECK_NUMBER
,      INVOICE_EXCHANGE_RATE
,      PAYMENT_CROSS_RATE
,      BANK_ACCOUNT_TYPE
,      ORIGINAL_INVOICE_ID
,      ORIGINAL_PAYMENT_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BANK_ACCOUNT_NUM
,      BANK_NUM
,      FUTURE_PAY_DUE_DATE
,      EXCLUSIVE_PAYMENT_FLAG
,      PROPOSED_PAYMENT_AMOUNT
,      PAY_SELECTED_CHECK_ID
,      PRINT_SELECTED_CHECK_ID
,      ORG_ID
,      WITHHOLDING_AMOUNT
,      INVOICE_PAYMENT_ID
,      DONT_PAY_DESCRIPTION
,      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
,      ADDRESS_LINE4
,      IBAN_NUMBER
,      CHECKRUN_ID
,      LEGAL_ENTITY_ID
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_GROUPING_NUMBER
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_EXCHANGE_RATE_TYPE
,      PAYMENT_EXCHANGE_DATE
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
FROM AP.AP_SELECTED_INVOICES_ALL;

Dependencies

[top of page]

AP.AP_SELECTED_INVOICES_ALL does not reference any database object

AP.AP_SELECTED_INVOICES_ALL is referenced by following:

APPS: AP_SELECTED_INVOICES; AP_SELECTED_INVOICES_ALL