eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POA_REP_PO_PURCHASES_V

Object Details

Object Name:	POA_REP_PO_PURCHASES_V
Object Type:	VIEW
Owner:	APPS
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Mandatory
ALL_ORGANIZATION	NUMBER
OPERATING_UNIT	NUMBER
ORGANIZATION	NUMBER	Yes
ALL_ITEM	NUMBER
COMMODITY	NUMBER
ITEM	NUMBER
ALL_TRADING_PARTNER	NUMBER
PARENT_SUPPLIER	NUMBER
SUPPLIER	NUMBER
SUPPLIER_SITE	NUMBER	Yes
ALL_PERSON	NUMBER
BUYER	NUMBER	Yes
ALL_GEOGRAPHY	NUMBER
WORLD_AREA_1	NUMBER
WORLD_AREA_2	NUMBER
COUNTRY	NUMBER
COUNTRY_REGION	NUMBER
STATE	NUMBER
ALL_TIME	NUMBER
YEAR	NUMBER
QUARTER	NUMBER
MONTH	NUMBER
ALL_DUNS	NUMBER
DUNS_GLOBAL_ULT	NUMBER
DUNS_DOMESTIC_ULT	NUMBER
DUNS_PARENT_NAME	NUMBER
DUNS_HEADQUARTERS	NUMBER
DUNS_NAME	NUMBER	Yes
UNSPSC_SEGMENT	NUMBER
UNSPSC_FAMILY	NUMBER
UNSPSC_CLASS	NUMBER
UNSPSC_COMMODITY	NUMBER
UNSPSC_FUNCTION	NUMBER	Yes
ALL_UNSPSC	NUMBER
PURCHASE_AMT	NUMBER
CONTRACT_AMT	NUMBER
NONCONTRACT_AMT	NUMBER
LEAKAGE_AMT	NUMBER
POTENTIAL_SVG_AMT	NUMBER
POS_POT_SVG_AMT	NUMBER
NEG_POT_SVG_AMT	NUMBER
PO_PRICE	NUMBER
PO_CREATION_CYCLE_TIME	NUMBER

Query Text

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


SELECT ALL_ORGANIZATION
,      OPERATING_UNIT
,      ORGANIZATION
,      ALL_ITEM
,      COMMODITY
,      ITEM
,      ALL_TRADING_PARTNER
,      PARENT_SUPPLIER
,      SUPPLIER
,      SUPPLIER_SITE
,      ALL_PERSON
,      BUYER
,      ALL_GEOGRAPHY
,      WORLD_AREA_1
,      WORLD_AREA_2
,      COUNTRY
,      COUNTRY_REGION
,      STATE
,      ALL_TIME
,      YEAR
,      QUARTER
,      MONTH
,      ALL_DUNS
,      DUNS_GLOBAL_ULT
,      DUNS_DOMESTIC_ULT
,      DUNS_PARENT_NAME
,      DUNS_HEADQUARTERS
,      DUNS_NAME
,      UNSPSC_SEGMENT
,      UNSPSC_FAMILY
,      UNSPSC_CLASS
,      UNSPSC_COMMODITY
,      UNSPSC_FUNCTION
,      ALL_UNSPSC
,      PURCHASE_AMT
,      CONTRACT_AMT
,      NONCONTRACT_AMT
,      LEAKAGE_AMT
,      POTENTIAL_SVG_AMT
,      POS_POT_SVG_AMT
,      NEG_POT_SVG_AMT
,      PO_PRICE
,      PO_CREATION_CYCLE_TIME
FROM APPS.POA_REP_PO_PURCHASES_V;

Dependencies

[top of page]

APPS.POA_REP_PO_PURCHASES_V references the following:

APPS: EDW_DUNS_M; EDW_GEOGRAPHY_M; EDW_HR_PERSON_M; EDW_ITEMS_M; EDW_ORGANIZATION_M; EDW_TIME_M; EDW_TRD_PARTNER_M; EDW_UNSPSC_M; POA_EDW_PO_DIST_F

APPS.POA_REP_PO_PURCHASES_V is not referenced by any database object