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_IDL_BS_J_MV

Object Details

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

M-View Details

Container:	POA_IDL_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:


AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
FII_AP_INV_B
FII_AP_INV_DIST_F
FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Comments
UMARKER	NUMBER		Union Operator Marker
FRID	ROWID	(10)	FRID
VRID	ROWID	(10)	VRID
VSRID	ROWID	(10)	VSRID
CRID	ROWID	(10)	CRID
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
COMPANY_ID	NUMBER	(15)	Company Identifier (Local Value Set)
COST_CENTER_ID	NUMBER	(15)	Cost center Identifier (Local Value Set)
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 Secondary Global Currency
PO_MATCHED_FLAG	VARCHAR2	(1)	Flag if Invoice is PO Matched or not
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)	Indicates whether shipment must be received before the invoice is paid

Query Text

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


SELECT UMARKER
,      FRID
,      VRID
,      VSRID
,      CRID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      INV_D_CREATED_BY
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMOUNT_B
,      AMOUNT_G
,      AMOUNT_SG
,      PO_MATCHED_FLAG
,      RECEIPT_REQUIRED_FLAG
FROM APPS.POA_IDL_BS_J_MV;

Dependencies

[top of page]

APPS.POA_IDL_BS_J_MV references the following:

AP: AP_SUPPLIERS; AP_SUPPLIER_SITES_ALL
APPS: POA_IDL_BS_J_MV
FII: FII_AP_INV_B; FII_AP_INV_DIST_F; FII_TIME_DAY

APPS.POA_IDL_BS_J_MV is referenced by following:

APPS: POA_IDL_001_MV; POA_IDL_BS_MV