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

TABLE: HR.PAY_COIN_ANAL_ELEMENTS

Object Details
Object Name: PAY_COIN_ANAL_ELEMENTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_COIN_ANAL_ELEMENTS
Subobject Name:
Status: VALID


This table holds the definitions for make-up of a cash payment.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_COIN_ANAL_ELEMENTS_PK
  1. ColumnCOIN_ANAL_ELEMENT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_COIN_ANAL_ELEMENTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOIN_ANAL_ELEMENT_ID
PAY_COIN_ANAL_ELEMENTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRE_PAYMENT_ID
PAY_COIN_ANAL_ELEMENTS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMONETARY_UNIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_COIN_ANAL_ELEMENTS PAY_COIN_ANAL_ELEMENTS_FK2 TablePAY_MONETARY_UNITS PAY_COIN_ANAL_ELEMENTS MONETARY_UNIT_ID
PAY_COIN_ANAL_ELEMENTS PAY_COIN_ANAL_ELEMENTS_FK1 TablePAY_PRE_PAYMENTS PAY_COIN_ANAL_ELEMENTS PRE_PAYMENT_ID
Columns
Name Datatype Length Mandatory Comments
COIN_ANAL_ELEMENT_ID NUMBER (15) Yes System-generated primary key column.
PRE_PAYMENT_ID NUMBER (15) Yes Foreign key to PAY_PRE_PAYMENTS.
MONETARY_UNIT_ID NUMBER (9) Yes Foreign key to PAY_MONETARY_UNITS.
NUMBER_OF_MONETARY_UNITS NUMBER (15) Yes Quantity of monetary units.
Query Text

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


SELECT COIN_ANAL_ELEMENT_ID
,      PRE_PAYMENT_ID
,      MONETARY_UNIT_ID
,      NUMBER_OF_MONETARY_UNITS
FROM HR.PAY_COIN_ANAL_ELEMENTS;

Dependencies

[top of page]

HR.PAY_COIN_ANAL_ELEMENTS does not reference any database object

HR.PAY_COIN_ANAL_ELEMENTS is referenced by following:

SchemaAPPS
SynonymPAY_COIN_ANAL_ELEMENTS
SchemaPUBLIC
SynonymPAY_COIN_ANAL_ELEMENTS