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

TABLE: HR.HR_S_PAYMENT_TYPES

Object Details
Object Name: HR_S_PAYMENT_TYPES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_S_PAYMENT_TYPES
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
PAYMENT_TYPE_ID NUMBER (9)
TERRITORY_CODE VARCHAR2 (2)
CURRENCY_CODE VARCHAR2 (15)
CATEGORY VARCHAR2 (2)
PAYMENT_TYPE_NAME VARCHAR2 (80)
ALLOW_AS_DEFAULT VARCHAR2 (30)
DESCRIPTION VARCHAR2 (80)
PRE_VALIDATION_REQUIRED VARCHAR2 (30)
PROCEDURE_NAME VARCHAR2 (61)
VALIDATION_DAYS NUMBER (15)
VALIDATION_VALUE VARCHAR2 (15)
LAST_UPDATE_DATE DATE

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

RECONCILIATION_FUNCTION VARCHAR2 (61)
PLSQL procedure for reconciling magnetic tape process.
Query Text

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


SELECT PAYMENT_TYPE_ID
,      TERRITORY_CODE
,      CURRENCY_CODE
,      CATEGORY
,      PAYMENT_TYPE_NAME
,      ALLOW_AS_DEFAULT
,      DESCRIPTION
,      PRE_VALIDATION_REQUIRED
,      PROCEDURE_NAME
,      VALIDATION_DAYS
,      VALIDATION_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      RECONCILIATION_FUNCTION
FROM HR.HR_S_PAYMENT_TYPES;

Dependencies

[top of page]

HR.HR_S_PAYMENT_TYPES does not reference any database object

HR.HR_S_PAYMENT_TYPES is referenced by following:

SchemaAPPS
SynonymHR_S_PAYMENT_TYPES
SchemaPUBLIC
SynonymHR_S_PAYMENT_TYPES