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_PBATCH_SET_LINES_ALL

Object Details

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

AP_PBATCH_SET_LINES_ALL stores the payment batch
set lines that make up a payment batch set. You need one
row for each payment batch that you would like to be created
when you submit the payment batch set to which the payment
batch set lines belong. Payment batch set lines belonging to a
payment batch set may use the same or different bank
accounts. However, they must use different payment
documents. The values from each row in this table are
used to insert a row in AP_INV_SELECTION_CRITERIA_ALL
when the payment batch set is submitted.
.
This table corresponds to the multi-row region in Payment Batch Sets window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_PBATCH_SET_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_SET_LINE_ID
AP_PBATCH_SET_LINES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_SET_ID BATCH_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NAME	VARCHAR2	(30)	Yes	Batch name for the payment batch set line. This is used to create the checkrun name using the batch set name for the payment batch set and the batch run name specified when submitting the payment batch set
BATCH_SET_LINE_ID	NUMBER	(15)	Yes	Payment batch set line identifier
BATCH_SET_ID	NUMBER	(15)	Yes	Payment batch set identifier
INCLUDE_IN_SET	VARCHAR2	(1)		Flag that determines if the payment batch set line will be used to create a payment batch when the payment batch set is submitted (Y or N)
PRINTER	VARCHAR2	(30)		Printer for the batch set line
CHECK_STOCK_ID	NUMBER	(15)	Yes	Payment document identifier
BANK_ACCOUNT_ID	NUMBER	(15)		No longer used
VENDOR_PAY_GROUP	VARCHAR2	(30)		Pay Group of supplier
HI_PAYMENT_PRIORITY	NUMBER	(2)		Highest payment priority of invoices to select
LOW_PAYMENT_PRIORITY	NUMBER	(2)		Lowest payment priority of invoices to select
MAX_PAYMENT_AMOUNT	NUMBER			Maximum amount for each payment in payment batch
MIN_CHECK_AMOUNT	NUMBER			Minimum amount for each payment in payment batch
MAX_OUTLAY	NUMBER			Maximum payment amount for an entire payment batch
PAY_ONLY_WHEN_DUE_FLAG	VARCHAR2	(1)		Flag that indicates if invoices will be selected by their due date only (Y or N)
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for a foreign currency payment
DOCUMENT_ORDER_LOOKUP_CODE	VARCHAR2	(30)		Type of payment ordering in a batch
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Payment currency code
AUDIT_REQUIRED_FLAG	VARCHAR2	(1)		Flag that indicates if an audit is required for Electronic payments
INTERVAL	NUMBER	(15)		Payment interval used for auditing Electronic payment batch
VOLUME_SERIAL_NUMBER	VARCHAR2	(6)		Identification number for tapes of Electronic payments made outside of e-Commerce Gateway
ZERO_AMOUNTS_ALLOWED	VARCHAR2	(1)		Flag that indicates if zero amount payments are allowed in payment batch (Y or N)
ZERO_INVOICES_ALLOWED	VARCHAR2	(1)		Flag that indicates if scheduled payments with zero amount remaining will be selected during payment batch (Y or N)
FUTURE_PMTS_ALLOWED	VARCHAR2	(1)		Flag that indicates if the payment batch is for future dated payments or not (Y or N)
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).
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		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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
ORG_ID	NUMBER	(15)		Organization identifier
INACTIVE_DATE	DATE			Inactive date
TRANSFER_PRIORITY	VARCHAR2	(30)		Transfer priority
VENDOR_ID	NUMBER	(15)		Supplier Identifier
CE_BANK_ACCT_USE_ID	NUMBER	(15)		Bank account identifier
DAYS_BETWEEN_CHECK_CYCLES	NUMBER	(15)		No Longer Used

Query Text

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


SELECT BATCH_NAME
,      BATCH_SET_LINE_ID
,      BATCH_SET_ID
,      INCLUDE_IN_SET
,      PRINTER
,      CHECK_STOCK_ID
,      BANK_ACCOUNT_ID
,      VENDOR_PAY_GROUP
,      HI_PAYMENT_PRIORITY
,      LOW_PAYMENT_PRIORITY
,      MAX_PAYMENT_AMOUNT
,      MIN_CHECK_AMOUNT
,      MAX_OUTLAY
,      PAY_ONLY_WHEN_DUE_FLAG
,      EXCHANGE_RATE_TYPE
,      DOCUMENT_ORDER_LOOKUP_CODE
,      PAYMENT_CURRENCY_CODE
,      AUDIT_REQUIRED_FLAG
,      INTERVAL
,      VOLUME_SERIAL_NUMBER
,      ZERO_AMOUNTS_ALLOWED
,      ZERO_INVOICES_ALLOWED
,      FUTURE_PMTS_ALLOWED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      INACTIVE_DATE
,      TRANSFER_PRIORITY
,      VENDOR_ID
,      CE_BANK_ACCT_USE_ID
,      DAYS_BETWEEN_CHECK_CYCLES
FROM AP.AP_PBATCH_SET_LINES_ALL;

Dependencies

[top of page]

AP.AP_PBATCH_SET_LINES_ALL does not reference any database object

AP.AP_PBATCH_SET_LINES_ALL is referenced by following:

APPS: AP_PBATCH_SET_LINES; AP_PBATCH_SET_LINES_ALL