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_AP_SPEND_V

Object Details

Object Name:	POA_REP_AP_SPEND_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	Length	Mandatory
ALL_ORGANIZATION	NUMBER
OPERATING_UNIT	NUMBER
ORGANIZATION	NUMBER		Yes
ALL_TRADING_PARTNER	NUMBER
PARENT_SUPPLIER	NUMBER
SUPPLIER	NUMBER
SUPPLIER_SITE	NUMBER		Yes
MINFLAG	VARCHAR2	(80)
WMNFLAG	VARCHAR2	(20)
SBUSFLAG	VARCHAR2	(20)
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
INVOICE_AMOUNT	NUMBER
MATCHED_AMOUNT	NUMBER
UNMATCHED_AMOUNT	NUMBER

Query Text

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


SELECT ALL_ORGANIZATION
,      OPERATING_UNIT
,      ORGANIZATION
,      ALL_TRADING_PARTNER
,      PARENT_SUPPLIER
,      SUPPLIER
,      SUPPLIER_SITE
,      MINFLAG
,      WMNFLAG
,      SBUSFLAG
,      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
,      INVOICE_AMOUNT
,      MATCHED_AMOUNT
,      UNMATCHED_AMOUNT
FROM APPS.POA_REP_AP_SPEND_V;

Dependencies

[top of page]

APPS.POA_REP_AP_SPEND_V references the following:

APPS: EDW_DUNS_M; EDW_GEOGRAPHY_M; EDW_HR_PERSON_M; EDW_ORGANIZATION_M; EDW_TIME_M; EDW_TRD_PARTNER_M; POA_FII_AP_INV_LINES_F_V

APPS.POA_REP_AP_SPEND_V is not referenced by any database object