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_API_BS_J_MV

Object Details

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

M-View Details

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

MV Log Dependencies:


FII_AP_INV_B
FII_AP_INV_DIST_F
FII_COM_CC_DIM_MAPS
FII_TIME_DAY
POA_DBI_POD_F
PO_COMMODITY_CATEGORIES

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	NUMBER		Union Operator Marker
FRID	ROWID	(10)	FRID
POFRID	ROWID	(10)	POFRID
COMRID	ROWID	(10)	COMRID
CRID	ROWID	(10)	CRID
MRID	ROWID	(10)	MRID
ORG_ID	NUMBER	(15)	Operating Unit Identifier
SUPPLIER_ID	NUMBER	(15)	Supplier Identifier
SUPPLIER_SITE_ID	NUMBER		Supplier Site Identifier
INV_D_CREATED_BY	NUMBER	(15)	Invoice Distribution Creator Identifier
COMMODITY_ID	NUMBER		Commodity Identifier
CATEGORY_ID	NUMBER		Category on the PO Line Identifier
PO_ITEM_ID	NUMBER		Purchased Item Identifier
BUYER_ID	NUMBER		Buyer Identifier
SHIP_TO_ORG_ID	NUMBER		Ship to Organization Identifier
BASE_UOM	VARCHAR2	(25)	Base UOM
COMPANY_ID	NUMBER	(15)	Company Identifier
COST_CENTER_ID	NUMBER	(15)	Cost-center Identifier
ENT_YEAR_ID	NUMBER		Enterprise Year Identifier
ENT_QTR_ID	NUMBER		Enterprise Quarter Identifier
ENT_PERIOD_ID	NUMBER		Enterprise Period Identifier
WEEK_ID	NUMBER		FII Week Identifier
DAY_ID	NUMBER		FII Day Identifier
AMOUNT_B	NUMBER		Invoice Amount in Functional Currency
AMOUNT_G	NUMBER		Invoice Amount in Global Currency
AMOUNT_SG	NUMBER		Invoice Amount in Global Currency
AMOUNT_FINANCED_B	NUMBER		Financed Amount in Functional Currency
AMOUNT_FINANCED_G	NUMBER		Financed Amount in Global Currency
AMOUNT_FINANCED_SG	NUMBER		Financed Amount in Secondary Global Currency
AMOUNT_RECOUPED_B	NUMBER		Recouped Amount in Functional Currency
AMOUNT_RECOUPED_G	NUMBER		Recouped Amount in Global Currency
AMOUNT_RECOUPED_SG	NUMBER		Recouped Amount in Secondary Global Currency
APPROVED_FLAG	VARCHAR2	(1)	Approved Flag
INVOICE_TYPE	VARCHAR2	(25)	Invoice Type
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Line Type Lookup Code

Query Text

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


SELECT UMARKER
,      FRID
,      POFRID
,      COMRID
,      CRID
,      MRID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      INV_D_CREATED_BY
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      SHIP_TO_ORG_ID
,      BASE_UOM
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMOUNT_B
,      AMOUNT_G
,      AMOUNT_SG
,      AMOUNT_FINANCED_B
,      AMOUNT_FINANCED_G
,      AMOUNT_FINANCED_SG
,      AMOUNT_RECOUPED_B
,      AMOUNT_RECOUPED_G
,      AMOUNT_RECOUPED_SG
,      APPROVED_FLAG
,      INVOICE_TYPE
,      LINE_TYPE_LOOKUP_CODE
FROM APPS.POA_API_BS_J_MV;

Dependencies

[top of page]

APPS.POA_API_BS_J_MV references the following:

APPS: POA_API_BS_J_MV
FII: FII_AP_INV_B; FII_AP_INV_DIST_F; FII_COM_CC_DIM_MAPS; FII_TIME_DAY
PO: PO_COMMODITY_CATEGORIES
POA: POA_DBI_POD_F

APPS.POA_API_BS_J_MV is referenced by following:

APPS: POA_API_001_MV; POA_API_BS_MV