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

TABLE: PA.PA_EI_DENORM_EFC

Object Details
Object Name: PA_EI_DENORM_EFC
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_EI_DENORM_EFC
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_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DENORM_ID NUMBER
Yes
NCU_SET_OF_BOOKS_ID NUMBER
Yes
CREATION_DATE DATE
Yes
QUANTITY_1 NUMBER

RAW_COST_RATE_1 NUMBER

RAW_COST_1 NUMBER

QUANTITY_2 NUMBER

RAW_COST_RATE_2 NUMBER

RAW_COST_2 NUMBER

QUANTITY_3 NUMBER

RAW_COST_RATE_3 NUMBER

RAW_COST_3 NUMBER

QUANTITY_4 NUMBER

RAW_COST_RATE_4 NUMBER

RAW_COST_4 NUMBER

QUANTITY_5 NUMBER

RAW_COST_RATE_5 NUMBER

RAW_COST_5 NUMBER

QUANTITY_6 NUMBER

RAW_COST_RATE_6 NUMBER

RAW_COST_6 NUMBER

QUANTITY_7 NUMBER

RAW_COST_RATE_7 NUMBER

RAW_COST_7 NUMBER

Query Text

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


SELECT DENORM_ID
,      NCU_SET_OF_BOOKS_ID
,      CREATION_DATE
,      QUANTITY_1
,      RAW_COST_RATE_1
,      RAW_COST_1
,      QUANTITY_2
,      RAW_COST_RATE_2
,      RAW_COST_2
,      QUANTITY_3
,      RAW_COST_RATE_3
,      RAW_COST_3
,      QUANTITY_4
,      RAW_COST_RATE_4
,      RAW_COST_4
,      QUANTITY_5
,      RAW_COST_RATE_5
,      RAW_COST_5
,      QUANTITY_6
,      RAW_COST_RATE_6
,      RAW_COST_6
,      QUANTITY_7
,      RAW_COST_RATE_7
,      RAW_COST_7
FROM PA.PA_EI_DENORM_EFC;

Dependencies

[top of page]

PA.PA_EI_DENORM_EFC does not reference any database object

PA.PA_EI_DENORM_EFC is referenced by following:

SchemaPA
ViewPA_EI_DENORM_EFC#