[Home] [Help] [Dependency Information]
Object Name: | PON_PRICE_ELEMENT_TYPES# |
---|---|
Object Type: | VIEW |
Owner: | PON |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_ELEMENT_TYPE_ID | NUMBER | Yes | ||
TRADING_PARTNER_ID | NUMBER | Yes | ||
PRICE_ELEMENT_CODE | VARCHAR2 | (30) | Yes | |
PRICING_BASIS | VARCHAR2 | (30) | Yes | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
SYSTEM_FLAG | VARCHAR2 | (1) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
ALLOCATION_BASIS | VARCHAR2 | (30) | ||
INVOICE_LINE_TYPE | VARCHAR2 | (30) | ||
COST_COMPONENT_CLASS_ID | NUMBER | |||
COST_ANALYSIS_CODE | VARCHAR2 | (4) | ||
COST_ACQUISITION_CODE | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_ELEMENT_TYPE_ID
, TRADING_PARTNER_ID
, PRICE_ELEMENT_CODE
, PRICING_BASIS
, ENABLED_FLAG
, SYSTEM_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ALLOCATION_BASIS
, INVOICE_LINE_TYPE
, COST_COMPONENT_CLASS_ID
, COST_ANALYSIS_CODE
, COST_ACQUISITION_CODE
, ZD_EDITION_NAME
FROM PON.PON_PRICE_ELEMENT_TYPES#;
|
|
|