VIEW: APPS.OPI_INV_ITEM_LOT_LVL_V

Source

View Text - Preformatted

SELECT (lots.lot_number || '-' || items.id) id, (lots.lot_number || '(' || items.value || ')') value, items.id item_org_id, lots.lot_number, items.inventory_item_id, items.organization_id FROM eni_oltp_item_star items, mtl_lot_numbers lots WHERE items.inventory_item_id = lots.inventory_item_id AND items.organization_id = lots.organization_id UNION ALL SELECT fnd_lv.lookup_code id, fnd_lv.meaning value, NULL item_org_id, NULL lot_number, NULL inventory_item_id, NULL organization_id FROM fnd_lookups fnd_lv WHERE FND_LV.lookup_type = 'OPI_DBI_ITEM_ATTRIB_DIM' AND FND_LV.lookup_code = '-2'

View Text - HTML Formatted

SELECT (LOTS.LOT_NUMBER || '-' || ITEMS.ID) ID
, (LOTS.LOT_NUMBER || '(' || ITEMS.VALUE || ')') VALUE
, ITEMS.ID ITEM_ORG_ID
, LOTS.LOT_NUMBER
, ITEMS.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
FROM ENI_OLTP_ITEM_STAR ITEMS
, MTL_LOT_NUMBERS LOTS
WHERE ITEMS.INVENTORY_ITEM_ID = LOTS.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = LOTS.ORGANIZATION_ID UNION ALL SELECT FND_LV.LOOKUP_CODE ID
, FND_LV.MEANING VALUE
, NULL ITEM_ORG_ID
, NULL LOT_NUMBER
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
FROM FND_LOOKUPS FND_LV
WHERE FND_LV.LOOKUP_TYPE = 'OPI_DBI_ITEM_ATTRIB_DIM'
AND FND_LV.LOOKUP_CODE = '-2'