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.PMIFV_BURDEN_V

Object Details

Object Name:	PMIFV_BURDEN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIFV_BURDEN_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Costing information for Burden (Overhead) details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BURDEN_QTY	NUMBER		Yes	Quantity of Burden used in calculating the burden cost
BURDEN_USAGE	NUMBER		Yes	Burden Usage - used in calculating the burden cost
BURDEN_UM	VARCHAR2	(4)		Burden uom used in calculating the burden cost
BURDEN_FACTOR	NUMBER		Yes	Burden factor used in calculating the burden cost
ROLLOVER_IND	NUMBER	(5)		Indicates if the burden cost has been frozen or not - 0 = not frozen
ITEM_QTY	NUMBER		Yes	Quantity of item used in calculating the burden cost
ITEM_UM	VARCHAR2	(4)		Item uom used in calculating the burden cost
BURDENLINE_ID	NUMBER	(10)	Yes	Surrogate for this burden line. (also posted to cm_acst_led.transline_id by Actual Cost Process)
ORGN_CODE	VARCHAR2	(4)		Organization for the burden
WHSE_CODE	VARCHAR2	(4)		Warehouse
ITEM_ID	NUMBER	(10)		Surrogate for item
RESOURCES	VARCHAR2	(16)	Yes	Resource used for the burden cost
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar
CALENDAR_DESCRIPTION	VARCHAR2	(40)		Costing Calendar description
PERIOD_CODE	VARCHAR2	(4)		Cost Period - specifies the start and end dates for the burden cost
PERIOD_DESCRIPTION	VARCHAR2	(40)		Costing Period Description
COST_MTHD_CODE	VARCHAR2	(4)		Specific costing method that the burden cost will be applied under
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Surrogate for component class
CMPNTCOST_ID	NUMBER	(10)		Surrogate to cost component details
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Analysis code
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT BURDEN_QTY
,      BURDEN_USAGE
,      BURDEN_UM
,      BURDEN_FACTOR
,      ROLLOVER_IND
,      ITEM_QTY
,      ITEM_UM
,      BURDENLINE_ID
,      ORGN_CODE
,      WHSE_CODE
,      ITEM_ID
,      RESOURCES
,      CALENDAR_CODE
,      CALENDAR_DESCRIPTION
,      PERIOD_CODE
,      PERIOD_DESCRIPTION
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      CMPNTCOST_ID
,      COST_ANALYSIS_CODE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM APPS.PMIFV_BURDEN_V;

Dependencies

[top of page]

APPS.PMIFV_BURDEN_V references the following:

APPS: CM_BRDN_DTL; CM_CLDR_DTL; CM_CLDR_HDR; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIFV_BURDEN_V is not referenced by any database object