[Home] [Help] [Dependency Information]
Object Name: | POA_PORTAL_PDIST2 |
---|---|
Object Type: | TABLE |
Owner: | POA |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_PK_KEY | NUMBER | |||
SUPPLIER_NAME | VARCHAR2 | (480) | ||
SUPPLIER_SITE_PK_KEY | NUMBER | |||
SUPPLIER_SITE_NAME | VARCHAR2 | (480) | ||
ITEM_PURCHASABLE_FLAG | VARCHAR2 | (10) | ||
SUM_PURCHASES | NUMBER | |||
SUM_LEAKAGE | NUMBER | |||
SUM_NON_CONTRACT | NUMBER | |||
AVG_CYCLE_TIME | NUMBER | |||
CNT_PO_LINES | NUMBER | |||
CNT_PO_HEADERS | NUMBER | |||
CNT_LATE_SUPPLIER_CONF | NUMBER | |||
AVG_LATE_SUP_CONF_AGE | NUMBER | |||
WEIGHT_AVG_CYCLE | NUMBER | |||
WEIGHT_AVG_CONF | NUMBER | |||
QUARTER | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIER_PK_KEY
, SUPPLIER_NAME
, SUPPLIER_SITE_PK_KEY
, SUPPLIER_SITE_NAME
, ITEM_PURCHASABLE_FLAG
, SUM_PURCHASES
, SUM_LEAKAGE
, SUM_NON_CONTRACT
, AVG_CYCLE_TIME
, CNT_PO_LINES
, CNT_PO_HEADERS
, CNT_LATE_SUPPLIER_CONF
, AVG_LATE_SUP_CONF_AGE
, WEIGHT_AVG_CYCLE
, WEIGHT_AVG_CONF
, QUARTER
FROM POA.POA_PORTAL_PDIST2;
POA.POA_PORTAL_PDIST2 does not reference any database object
POA.POA_PORTAL_PDIST2 is referenced by following:
|
|
|