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]

MATERIALIZED VIEW: APPS.POA_PQC_BS_J_MV

Object Details

Object Name:	POA_PQC_BS_J_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	POA_PQC_BS_J_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


FII_COM_CC_DIM_MAPS
FII_TIME_DAY
POA_DBI_POD_F
PO_COMMODITY_CATEGORIES

[View Source Query]

Columns

Name	Datatype	Length	Mandatory	Comments
FRID	ROWID	(10)		FRID
CRID	ROWID	(10)		CRID
COMRID	ROWID	(10)		COMRID
MRID	ROWID	(10)		MRID
ORG_ID	NUMBER			Operating Unit Identifier
SHIP_TO_ORG_ID	NUMBER			Ship to Organization Identifier
COMMODITY_ID	NUMBER			Commodity Identifier
BASE_UOM	VARCHAR2	(25)		Base UOM
SUPPLIER_ID	NUMBER			Supplier Identifier
SUPPLIER_SITE_ID	NUMBER			Supplier Site Identifier
CATEGORY_ID	NUMBER			Category on the PO Line Identifier
PO_ITEM_ID	NUMBER		Yes	Purchased Item Identifier
BUYER_ID	NUMBER		Yes	Buyer Identifier
COMPANY_ID	NUMBER	(15)		Company identifier
COST_CENTER_ID	NUMBER	(15)		Cost-center Identifier
ENT_QTR_ID	NUMBER			Enterprise Quarter Identifier
ENT_PERIOD_ID	NUMBER			Enterprise Period Identifier
WEEK_ID	NUMBER		Yes	FII Week Identifier
DAY_ID	NUMBER		Yes	FII Day Identifier
PURCHASE_AMT_B	NUMBER			Purchased Amount in functional currency
PURCHASE_AMT_G	NUMBER			Purchased Amount in global currency
PURCHASE_AMT_SG	NUMBER			Purchased Amount in secondary global currency
QUANTITY	NUMBER			Quantity in Base UOM
P_ENT_YEAR_ID	NUMBER			prior enterprise year identifier
ENT_YEAR_ID	NUMBER			Enterprise Year Identifier
GLOBAL_CUR_CONV_RATE	NUMBER			Global currency conversion rate
PO_HEADER_ID	NUMBER		Yes	PO header identifier
PO_LINE_ID	NUMBER		Yes	PO line identifier
PO_RELEASE_ID	NUMBER			PO release identifier
APPROVED_DATE	DATE			Earliest approval date
CONSIGNED_CODE	NUMBER			Consigned Code
ORDER_TYPE	VARCHAR2	(25)		Order Type
COMPLEX_WORK_FLAG	VARCHAR2	(1)		Complex work flag
LINE_LOCATION_ID	NUMBER			PO Shipment Identifier
PO_DISTRIBUTION_ID	NUMBER		Yes	PO Distribution Identifier

Query Text

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


SELECT FRID
,      CRID
,      COMRID
,      MRID
,      ORG_ID
,      SHIP_TO_ORG_ID
,      COMMODITY_ID
,      BASE_UOM
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      QUANTITY
,      P_ENT_YEAR_ID
,      ENT_YEAR_ID
,      GLOBAL_CUR_CONV_RATE
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      APPROVED_DATE
,      CONSIGNED_CODE
,      ORDER_TYPE
,      COMPLEX_WORK_FLAG
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
FROM APPS.POA_PQC_BS_J_MV;

Dependencies

[top of page]

APPS.POA_PQC_BS_J_MV references the following:

APPS: POA_PQC_BS_J_MV
FII: FII_COM_CC_DIM_MAPS; FII_TIME_DAY
PO: PO_COMMODITY_CATEGORIES
POA: POA_DBI_POD_F

APPS.POA_PQC_BS_J_MV is referenced by following:

APPS: POA_BM_ITEM_O_MV; POA_BM_ITEM_S_MV; POA_PQC_BS_J2_MV