View: PMIFV_BURDEN_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing information for Burden (Overhead) details
Implementation/DBA Data:	APPS.PMIFV_BURDEN_V

View Text

SELECT /* REGULAR ATTRIBUTES */ BURDEN.BURDEN_QTY
, BURDEN.BURDEN_USAGE
, BURDEN.BURDEN_UM
, BURDEN.BURDEN_FACTOR
, BURDEN.ROLLOVER_IND
, BURDEN.ITEM_QTY
, BURDEN.ITEM_UM
, /* ID */ BURDEN.BURDENLINE_ID
, BURDEN.ORGN_CODE
, BURDEN.WHSE_CODE
, BURDEN.ITEM_ID
, BURDEN.RESOURCES
, BURDEN.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, BURDEN.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, BURDEN.COST_MTHD_CODE
, BURDEN.COST_CMPNTCLS_ID
, BURDEN.CMPNTCOST_ID
, BURDEN.COST_ANALYSIS_CODE
, /* RESOLVED FOREIGN KEYS */ /* WHO */ BURDEN.LAST_UPDATED_BY
, BURDEN.CREATED_BY
, BURDEN.LAST_UPDATE_DATE
, BURDEN.CREATION_DATE
FROM CM_BRDN_DTL BURDEN
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE BURDEN.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND BURDEN.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND BURDEN.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND (BURDEN.DELETE_MARK = 0 OR BURDEN.DELETE_MARK IS NULL)
AND (BURDEN.ORGN_CODE IS NULL OR BURDEN.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY

Columns