Skip to content

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

TABLE: HR.HR_H2PI_PAYMENT_METHODS

Object Details
Object Name: HR_H2PI_PAYMENT_METHODS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_H2PI_PAYMENT_METHODS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
CLIENT_ID NUMBER (15) Yes Client id
PERSONAL_PAYMENT_METHOD_ID NUMBER (9) Yes System generated primary key column
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
PERSON_ID NUMBER (10) Yes Person ID
EFFECTIVE_START_DATE DATE
Yes Effective start date of personal payment method
EFFECTIVE_END_DATE DATE
Yes Effective end date personal payment method
ORG_PAYMENT_METHOD_ID NUMBER (9) Yes Organization payment method ID
AMOUNT NUMBER

Amount
PERCENTAGE NUMBER (22)
Percentage
PRIORITY NUMBER (15)
Priority
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
PAYEE_ID NUMBER (15)
Payee ID
PAYEE_TYPE VARCHAR2 (30)
Payee type
TERRITORY_CODE VARCHAR2 (2)
Territory code
PRENOTE_DATE DATE

Prenote date
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column
STATUS VARCHAR2 (1)
Status of record for upload
Query Text

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


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      CLIENT_ID
,      PERSONAL_PAYMENT_METHOD_ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ORG_PAYMENT_METHOD_ID
,      AMOUNT
,      PERCENTAGE
,      PRIORITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      PAYEE_ID
,      PAYEE_TYPE
,      TERRITORY_CODE
,      PRENOTE_DATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      STATUS
FROM HR.HR_H2PI_PAYMENT_METHODS;

Dependencies

[top of page]

HR.HR_H2PI_PAYMENT_METHODS does not reference any database object

HR.HR_H2PI_PAYMENT_METHODS is referenced by following:

SchemaHR
ViewHR_H2PI_PAYMENT_METHODS#