VIEW: APPS.IC_ITEM_LOCT_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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