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: APPS.PAY_ORG_PAYMENT_METHODS_F_VL

Object Details

Object Name:	PAY_ORG_PAYMENT_METHODS_F_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_ORG_PAYMENT_METHODS_F_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Join of base and translation tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id value
ORG_PAYMENT_METHOD_ID	NUMBER	(9)	Yes	Org payment method id of PAY_ORG_PAYMENT_METHODS_F table
EFFECTIVE_START_DATE	DATE		Yes	Effective start date
EFFECTIVE_END_DATE	DATE		Yes	Effective end date
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group id
EXTERNAL_ACCOUNT_ID	NUMBER	(9)		External account id of PAY_EXTERNAL_ACCOUNTS table
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
PAYMENT_TYPE_ID	NUMBER	(9)	Yes	Payment type id of PAY_PAYMENT_TYPES table
DEFINED_BALANCE_ID	NUMBER	(9)		Balance type with its corresponding dimension
ORG_PAYMENT_METHOD_NAME	VARCHAR2	(80)	Yes	Organization payment method name
COMMENT_ID	NUMBER	(15)		Comment information
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Developer descriptive flex field
ATTRIBUTE1	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE2	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE3	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE4	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE5	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE6	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE7	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE8	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE9	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE10	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE11	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE12	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE13	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE14	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE15	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE16	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE17	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE18	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE19	VARCHAR2	(150)		Developer descriptive flex field segment
ATTRIBUTE20	VARCHAR2	(150)		Developer descriptive flex field segment
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
PMETH_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flex field
PMETH_INFORMATION1	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION2	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION3	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION4	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION5	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION6	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION7	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION8	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION9	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION10	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION11	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION12	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION13	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION14	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION15	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION16	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION17	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION18	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION19	VARCHAR2	(150)		Developer descriptive flex field segment
PMETH_INFORMATION20	VARCHAR2	(150)		Developer descriptive flex field segment
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.

Query Text

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


SELECT ROW_ID
,      ORG_PAYMENT_METHOD_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      EXTERNAL_ACCOUNT_ID
,      CURRENCY_CODE
,      PAYMENT_TYPE_ID
,      DEFINED_BALANCE_ID
,      ORG_PAYMENT_METHOD_NAME
,      COMMENT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PMETH_INFORMATION_CATEGORY
,      PMETH_INFORMATION1
,      PMETH_INFORMATION2
,      PMETH_INFORMATION3
,      PMETH_INFORMATION4
,      PMETH_INFORMATION5
,      PMETH_INFORMATION6
,      PMETH_INFORMATION7
,      PMETH_INFORMATION8
,      PMETH_INFORMATION9
,      PMETH_INFORMATION10
,      PMETH_INFORMATION11
,      PMETH_INFORMATION12
,      PMETH_INFORMATION13
,      PMETH_INFORMATION14
,      PMETH_INFORMATION15
,      PMETH_INFORMATION16
,      PMETH_INFORMATION17
,      PMETH_INFORMATION18
,      PMETH_INFORMATION19
,      PMETH_INFORMATION20
,      OBJECT_VERSION_NUMBER
FROM APPS.PAY_ORG_PAYMENT_METHODS_F_VL;

Dependencies

[top of page]

APPS.PAY_ORG_PAYMENT_METHODS_F_VL references the following:

APPS: PAY_ORG_PAYMENT_METHODS_F; PAY_ORG_PAYMENT_METHODS_F_TL

APPS.PAY_ORG_PAYMENT_METHODS_F_VL is referenced by following:

PUBLIC: PAY_ORG_PAYMENT_METHODS_F_VL