DBA Data[Home] [Help]

VIEW: APPS.PMIBV_BURDEN_V

Source

View Text - Preformatted

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 , burden.PERIOD_CODE , 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 WHERE (burden.delete_mark = 0 OR burden.delete_mark IS NULL) with read only
View Text - HTML Formatted

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
, BURDEN.PERIOD_CODE
, 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
WHERE (BURDEN.DELETE_MARK = 0 OR BURDEN.DELETE_MARK IS NULL) WITH READ ONLY