View: IC_ITEM_LOCT_VW

Product:	GMF - Process Manufacturing Financials
Description:	Used in Financials for Lots
Implementation/DBA Data:	APPS.IC_ITEM_LOCT_VW

View Text

SELECT LI.WHSE_CODE || DECODE(IM.LOCT_CTL
, 0
, ''
, '.' || LI.LOCATION ) || DECODE(IM.LOT_CTL
, 0
, ''
, ':' || LM.LOT_NO) || DECODE(IM.SUBLOT_CTL
, 0
, ''
, '.' || LM.SUBLOT_NO) LOC_CODE
, MSI.INVENTORY_ITEM_ID ORA_ITEM_ID
, IM.ITEM_ID DLX_ITEM_ID
, IM.ITEM_NO ITEM_NO
, IM.DUALUM_IND DUALUM_IND
, IM.ITEM_UM PRIMARY_UOM
, IM.ITEM_UM2 SECONDARY_UOM
, DECODE(IM.LOCT_CTL
, 0
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, LI.LOCATION) LOCATION
, DECODE(IM.LOT_CTL
, 0
, 0
, LM.LOT_ID) LOT_ID
, DECODE(IM.LOT_CTL
, 0
, ' '
, LM.LOT_NO) LOT_NO
, DECODE(IM.SUBLOT_CTL
, 0
, ' '
, LM.SUBLOT_NO) SUBLOT_NO
, DECODE(IM.GRADE_CTL
, 0
, ' '
, LM.QC_GRADE) QC_GRADE
, LI.WHSE_CODE WHSE_CODE
, IM.WHSE_ITEM_ID WHSE_ITEM_ID
, DECODE(IM.LOT_CTL
, 0
, ' '
, IM.LOT_STATUS) LOT_STATUS FROM IC_LOTS_MST LM
, IC_LOCT_MST LI
, IC_ITEM_MST IM
, MTL_SYSTEM_ITEMS MSI
WHERE IM.ITEM_ID = LM.ITEM_ID AND IM.ITEM_NO = MSI.SEGMENT1 AND LI.LOCATION = DECODE(IM.LOCT_CTL
, 0
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, LI.LOCATION) AND IM.DELETE_MARK = 0

Columns