[Home] [Help] [Dependency Information]
Object Name: | POA_REP_PO_PURCHASES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.POA_REP_PO_PURCHASES_V is not referenced by any database object
|
|
|