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: IBY.IBY_ACCT_PMT_PROFILES_B

Object Details

Object Name:	IBY_ACCT_PMT_PROFILES_B
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_ACCT_PMT_PROFILES_B
Subobject Name:
Status:	VALID

IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables is defined in the view IBY_PAYMENT_PROFILES. The selection of a payment process profile is driven by the payment method assigned to a document and other factors. This table corresponds to the Payment Process Profiles pages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_ACCT_PMT_PROFILES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_PROFILE_ID
IBY_ACCT_PMT_PROFILES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_PROFILE_CODE
IBY_ACCT_PMT_PROFILES_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BEP_ACCOUNT_ID
IBY_ACCT_PMT_PROFILES_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSMIT_CONFIGURATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_PROFILE_ID	NUMBER	(15)	Yes	System generated primary key
SYSTEM_PROFILE_CODE	VARCHAR2	(100)	Yes	System payment process profile Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
BEP_ACCOUNT_ID	NUMBER	(15)		Payment system account Identifier
SECURITY_CONFIGURATION_ID	NUMBER	(15)		Security configuration Identifier
TRANSMIT_CONFIGURATION_ID	NUMBER	(15)		Transmission configuration Identifier
RESET_VALUE_1	NUMBER	(15)		Value to which the first sequence is reset
LAST_USED_NUMBER_1	NUMBER	(15)		Last number that was used by the first sequence
RESET_REQUEST_1	NUMBER	(15)		Identifier of the concurrent request used to reset the first sequence
RESET_VALUE_2	NUMBER	(15)		Value to which the second sequence is reset
LAST_USED_NUMBER_2	NUMBER	(15)		Last number that was used by the second sequence
RESET_REQUEST_2	NUMBER	(15)		Identifier of the concurrent request used to reset the second sequence
RESET_VALUE_3	NUMBER	(15)		Value to which the third sequence is reset
LAST_USED_NUMBER_3	NUMBER	(15)		Last number that was used by the third sequence
RESET_REQUEST_3	NUMBER	(15)		Identifier of the concurrent request used to reset the third sequence
INACTIVE_DATE	DATE			Inactive date
ACK_SEC_CONFIG_ID	NUMBER	(15)		Security configuration Identifier for acknowledgement file
ACK_TRANSMIT_CONFIG_ID	NUMBER	(15)		Transmission configuration Identifier for acknowledgement file

Query Text

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


SELECT PAYMENT_PROFILE_ID
,      SYSTEM_PROFILE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BEP_ACCOUNT_ID
,      SECURITY_CONFIGURATION_ID
,      TRANSMIT_CONFIGURATION_ID
,      RESET_VALUE_1
,      LAST_USED_NUMBER_1
,      RESET_REQUEST_1
,      RESET_VALUE_2
,      LAST_USED_NUMBER_2
,      RESET_REQUEST_2
,      RESET_VALUE_3
,      LAST_USED_NUMBER_3
,      RESET_REQUEST_3
,      INACTIVE_DATE
,      ACK_SEC_CONFIG_ID
,      ACK_TRANSMIT_CONFIG_ID
FROM IBY.IBY_ACCT_PMT_PROFILES_B;

Dependencies

[top of page]

IBY.IBY_ACCT_PMT_PROFILES_B does not reference any database object

IBY.IBY_ACCT_PMT_PROFILES_B is referenced by following:

APPS: IBY_ACCT_PMT_PROFILES_B