View: PMIFV_BATCH_TRANS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Batch Transaction Details
Implementation/DBA Data:	APPS.PMIFV_BATCH_TRANS_V

View Text

SELECT TRANCMP.ORGN_CODE
, TRANCMP.CO_CODE
, TRANCMP.WHSE_CODE
, TRANCMP.DOC_ID
, TRANCMP.ITEM_ID
, TRANCMP.LOT_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, ITEMMST.ITEM_UM
, SUBSTR(PMI_PRODUCTION_SUM.FIND_PROD_GRADE(TRANCMP.TRANS_ID
, TRANCMP.ITEM_ID
, TRANCMP.LOT_ID)
, 1
, 4)
, TRANCMP.TRANS_QTY
, TRANCMP.TRANS_QTY*PMI_COMMON_PKG.PMICO_GET_COST(TRANCMP.ITEM_ID
, TRANCMP.WHSE_CODE
, NULL
, TRANCMP.TRANS_DATE)
, CALENDR.PERIOD_YEAR
, CALENDR.PERIOD_NUM
, CALENDR.PERIOD_NAME
, PLCYMST.BASE_CURRENCY_CODE
FROM IC_TRAN_CMP_VW1 TRANCMP
, IC_ITEM_MST ITEMMST
, PMI_GL_CALENDAR_V CALENDR
, GL_PLCY_MST PLCYMST
WHERE TRANCMP.ITEM_ID = ITEMMST.ITEM_ID
AND TRANCMP.CO_CODE = PLCYMST.CO_CODE
AND TRANCMP.LINE_TYPE=1
AND TRANCMP.TRANS_QTY <> 0
AND TRANCMP.CO_CODE = CALENDR.CO_CODE
AND TRUNC(TRANCMP.TRANS_DATE) BETWEEN CALENDR.START_DATE
AND CALENDR.END_DATE
AND (TRANCMP.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