VIEW: APPS.PMIFV_ITEM_COST_FROM_GL_V

Source

View Text - Preformatted

SELECT costdetail.CMPTCOST_AMT, costdetail.ITEMCOST_ID, /* ID */ costdetail.COST_CMPNTCLS_ID, costdetail.COST_ANALYSIS_CODE, glitemcost.ORGN_CODE, orgn.ORGN_NAME, glitemcost.WHSE_CODE, whse.WHSE_NAME, glitemcost.ITEM_ID, glitemcost.COST_MTHD_CODE, glitemcost.CALENDAR_CODE, cldrhdr.CALENDAR_DESC, glitemcost.PERIOD_CODE, cldrdtl.PERIOD_DESC, cldrdtl.start_date, cldrdtl.end_date, glitemcost.FMEFF_ID, glitemcost.ITEMCOST_ID, item.item_no, item.item_desc1, item.item_um, item.item_um2, costmaster.COST_CMPNTCLS_CODE, costmaster.COST_CMPNTCLS_DESC, costmaster.SORT_SEQUENCE, costmaster.USAGE_IND, costmaster.PRIMARY_CMPNTCLS_ID, costmaster.PRODUCT_COST_IND, costmaster.UPDATE_COST_IND, costmaster.CMPNT_GROUP, costmaster.PPV_IND, glitemcost.FINAL_FLAG, glitemcost.END_DATE, glitemcost.START_DATE, glitemcost.COST_TYPE, glitemcost.ACCTG_COST, costdetail.CREATED_BY, /* Who columns */ costdetail.CREATION_DATE, costdetail.LAST_UPDATE_DATE, costdetail.LAST_UPDATED_BY FROM gl_item_dtl costdetail, cm_cmpt_mst costmaster, gl_item_cst glitemcost, ic_item_mst_b item, IC_WHSE_MST WHSE, SY_ORGN_MST ORGN, CM_CLDR_HDR cldrhdr, CM_CLDR_DTL cldrdtl WHERE costmaster.cost_cmpntcls_id = costdetail.cost_cmpntcls_id and costdetail.itemcost_id = glitemcost.itemcost_id and glitemcost.item_id = item.item_id and glitemcost.ORGN_CODE = orgn.orgn_code and glitemcost.WHSE_CODE = WHSE.WHSE_code and glitemcost.CALENDAR_CODE = cldrhdr.CALENDAR_CODE(+) and glitemcost.calendar_code = cldrdtl.calendar_code(+) and glitemcost.period_code = cldrdtl.period_code(+) and costdetail.delete_mark = 0 and (glitemcost.orgn_code is NULL or glitemcost.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

View Text - HTML Formatted

SELECT COSTDETAIL.CMPTCOST_AMT
, COSTDETAIL.ITEMCOST_ID
, /* ID */ COSTDETAIL.COST_CMPNTCLS_ID
, COSTDETAIL.COST_ANALYSIS_CODE
, GLITEMCOST.ORGN_CODE
, ORGN.ORGN_NAME
, GLITEMCOST.WHSE_CODE
, WHSE.WHSE_NAME
, GLITEMCOST.ITEM_ID
, GLITEMCOST.COST_MTHD_CODE
, GLITEMCOST.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, GLITEMCOST.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, CLDRDTL.START_DATE
, CLDRDTL.END_DATE
, GLITEMCOST.FMEFF_ID
, GLITEMCOST.ITEMCOST_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTMASTER.COST_CMPNTCLS_DESC
, COSTMASTER.SORT_SEQUENCE
, COSTMASTER.USAGE_IND
, COSTMASTER.PRIMARY_CMPNTCLS_ID
, COSTMASTER.PRODUCT_COST_IND
, COSTMASTER.UPDATE_COST_IND
, COSTMASTER.CMPNT_GROUP
, COSTMASTER.PPV_IND
, GLITEMCOST.FINAL_FLAG
, GLITEMCOST.END_DATE
, GLITEMCOST.START_DATE
, GLITEMCOST.COST_TYPE
, GLITEMCOST.ACCTG_COST
, COSTDETAIL.CREATED_BY
, /* WHO COLUMNS */ COSTDETAIL.CREATION_DATE
, COSTDETAIL.LAST_UPDATE_DATE
, COSTDETAIL.LAST_UPDATED_BY
FROM GL_ITEM_DTL COSTDETAIL
, CM_CMPT_MST COSTMASTER
, GL_ITEM_CST GLITEMCOST
, IC_ITEM_MST_B ITEM
, IC_WHSE_MST WHSE
, SY_ORGN_MST ORGN
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.ITEMCOST_ID = GLITEMCOST.ITEMCOST_ID
AND GLITEMCOST.ITEM_ID = ITEM.ITEM_ID
AND GLITEMCOST.ORGN_CODE = ORGN.ORGN_CODE
AND GLITEMCOST.WHSE_CODE = WHSE.WHSE_CODE
AND GLITEMCOST.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND GLITEMCOST.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND GLITEMCOST.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.DELETE_MARK = 0
AND (GLITEMCOST.ORGN_CODE IS NULL OR GLITEMCOST.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