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

TABLE: POA.POA_PORTAL_PDIST

Object Details
Object Name: POA_PORTAL_PDIST
Object Type: TABLE
Owner: POA
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_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_PK_KEY NUMBER

OPERATING_UNIT_NAME VARCHAR2 (500)
SUPPLIER_PK_KEY NUMBER

SUPPLIER_NAME VARCHAR2 (480)
CATEGORY_PK_KEY NUMBER

CATEGORY_NAME VARCHAR2 (240)
SUM_PURCHASES NUMBER

SUM_LEAKAGE NUMBER

SUM_NON_CONTRACT NUMBER

AVG_CYCLE_TIME NUMBER

CNT_PO_LINES NUMBER

QUARTER VARCHAR2 (1)
CNT_LATE_SUPPLIER_CONF NUMBER

AVG_LATE_SUP_CONF_AGE NUMBER

WEIGHT_AVG_CYCLE NUMBER

WEIGHT_AVG_CONF NUMBER

ITEM_PURCHASABLE_FLAG VARCHAR2 (10)
CNT_PO_HEADERS NUMBER

ORGANIZATION_NAME VARCHAR2 (500)
ORGANIZATION_PK_KEY NUMBER

SUM_CONTRACT NUMBER

POS_POTENTIAL_SVG NUMBER

NEG_POTENTIAL_SVG NUMBER

SUM_LATE_PURCHASES NUMBER

Query Text

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


SELECT OPERATING_UNIT_PK_KEY
,      OPERATING_UNIT_NAME
,      SUPPLIER_PK_KEY
,      SUPPLIER_NAME
,      CATEGORY_PK_KEY
,      CATEGORY_NAME
,      SUM_PURCHASES
,      SUM_LEAKAGE
,      SUM_NON_CONTRACT
,      AVG_CYCLE_TIME
,      CNT_PO_LINES
,      QUARTER
,      CNT_LATE_SUPPLIER_CONF
,      AVG_LATE_SUP_CONF_AGE
,      WEIGHT_AVG_CYCLE
,      WEIGHT_AVG_CONF
,      ITEM_PURCHASABLE_FLAG
,      CNT_PO_HEADERS
,      ORGANIZATION_NAME
,      ORGANIZATION_PK_KEY
,      SUM_CONTRACT
,      POS_POTENTIAL_SVG
,      NEG_POTENTIAL_SVG
,      SUM_LATE_PURCHASES
FROM POA.POA_PORTAL_PDIST;

Dependencies

[top of page]

POA.POA_PORTAL_PDIST does not reference any database object

POA.POA_PORTAL_PDIST is referenced by following:

SchemaAPPS
SynonymPOA_PORTAL_PDIST