VIEW: APPS.OPI_INV_ITEM_GRADE_LVL_V

Source

View Text - Preformatted

SELECT DISTINCT (lots.grade_code || '-' || items.id) id, (lots.grade_code || '(' || items.value || ')') value, items.id item_org_id, lots.grade_code, 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 AND lots.grade_code IS NOT NULL UNION ALL SELECT fnd_lv.lookup_code id, fnd_lv.meaning value, NULL item_org_id, NULL grade_code, 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 = '-1'

View Text - HTML Formatted

SELECT DISTINCT (LOTS.GRADE_CODE || '-' || ITEMS.ID) ID
, (LOTS.GRADE_CODE || '(' || ITEMS.VALUE || ')') VALUE
, ITEMS.ID ITEM_ORG_ID
, LOTS.GRADE_CODE
, 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
AND LOTS.GRADE_CODE IS NOT NULL UNION ALL SELECT FND_LV.LOOKUP_CODE ID
, FND_LV.MEANING VALUE
, NULL ITEM_ORG_ID
, NULL GRADE_CODE
, 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 = '-1'