Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.PAY_ORG_PAYMENT_METHODS_F#

Object Details
Object Name: PAY_ORG_PAYMENT_METHODS_F#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_PAYMENT_METHOD_ID NUMBER (9) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
EXTERNAL_ACCOUNT_ID NUMBER (9)
CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_TYPE_ID NUMBER (9) Yes
DEFINED_BALANCE_ID NUMBER (9)
ORG_PAYMENT_METHOD_NAME VARCHAR2 (80) Yes
COMMENT_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

PMETH_INFORMATION_CATEGORY VARCHAR2 (30)
PMETH_INFORMATION1 VARCHAR2 (150)
PMETH_INFORMATION2 VARCHAR2 (150)
PMETH_INFORMATION3 VARCHAR2 (150)
PMETH_INFORMATION4 VARCHAR2 (150)
PMETH_INFORMATION5 VARCHAR2 (150)
PMETH_INFORMATION6 VARCHAR2 (150)
PMETH_INFORMATION7 VARCHAR2 (150)
PMETH_INFORMATION8 VARCHAR2 (150)
PMETH_INFORMATION9 VARCHAR2 (150)
PMETH_INFORMATION10 VARCHAR2 (150)
PMETH_INFORMATION11 VARCHAR2 (150)
PMETH_INFORMATION12 VARCHAR2 (150)
PMETH_INFORMATION13 VARCHAR2 (150)
PMETH_INFORMATION14 VARCHAR2 (150)
PMETH_INFORMATION15 VARCHAR2 (150)
PMETH_INFORMATION16 VARCHAR2 (150)
PMETH_INFORMATION17 VARCHAR2 (150)
PMETH_INFORMATION18 VARCHAR2 (150)
PMETH_INFORMATION19 VARCHAR2 (150)
PMETH_INFORMATION20 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9)
TRANSFER_TO_GL_FLAG VARCHAR2 (30)
COST_PAYMENT VARCHAR2 (30)
COST_CLEARED_PAYMENT VARCHAR2 (30)
COST_CLEARED_VOID_PAYMENT VARCHAR2 (30)
EXCLUDE_MANUAL_PAYMENT VARCHAR2 (30)
TYPE VARCHAR2 (30)
ORGANIZATION_ID NUMBER (15)
TIME_DEFINITION_ID NUMBER (9)
PARENT_ORG_PAYMENT_METHOD_ID NUMBER (9)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT 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
,      TRANSFER_TO_GL_FLAG
,      COST_PAYMENT
,      COST_CLEARED_PAYMENT
,      COST_CLEARED_VOID_PAYMENT
,      EXCLUDE_MANUAL_PAYMENT
,      TYPE
,      ORGANIZATION_ID
,      TIME_DEFINITION_ID
,      PARENT_ORG_PAYMENT_METHOD_ID
,      ZD_EDITION_NAME
FROM HR.PAY_ORG_PAYMENT_METHODS_F#;

Dependencies

[top of page]

HR.PAY_ORG_PAYMENT_METHODS_F# references the following:

SchemaHR
TablePAY_ORG_PAYMENT_METHODS_F
HR.PAY_ORG_PAYMENT_METHODS_F# is referenced by following:

SchemaAPPS
TriggerPAY_ORG_PAYMENT_METHODS_BRUID
SynonymPAY_ORG_PAYMENT_METHODS_F
TriggerPAY_ORG_PAYMENT_METHODS_F+
TriggerPAY_ORG_PAYMENT_METHODS_F_OVN
TriggerPAY_ORG_PAYMENT_METHODS_F_WHO