[Home] [Help] [Dependency Information]
Object Name: | PA_EI_DENORM_EFC# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|