VIEW: APPS.OPI_LOCATORS_V

Source

View Text - Preformatted

SELECT (locs.inventory_location_id || '-' || subs.id) id, (locs.concatenated_segments || '(' || subs.value || ')') value, subs.id sub_org_code, locs.inventory_location_id locator_id, subs.subinventory_code, subs.organization_id FROM opi_subinventories_v subs, mtl_item_locations_kfv locs WHERE subs.organization_id = locs.organization_id AND subs.subinventory_code = locs.subinventory_code UNION ALL SELECT fnd_lv.lookup_code id, fnd_lv.meaning value, NULL sub_org_code, NULL locator_id, NULL subinventory_code, NULL organization_id FROM fnd_lookups fnd_lv WHERE FND_LV.lookup_type = 'OPI_DBI_SUBINV' AND FND_LV.lookup_code = '-1'

View Text - HTML Formatted

SELECT (LOCS.INVENTORY_LOCATION_ID || '-' || SUBS.ID) ID
, (LOCS.CONCATENATED_SEGMENTS || '(' || SUBS.VALUE || ')') VALUE
, SUBS.ID SUB_ORG_CODE
, LOCS.INVENTORY_LOCATION_ID LOCATOR_ID
, SUBS.SUBINVENTORY_CODE
, SUBS.ORGANIZATION_ID
FROM OPI_SUBINVENTORIES_V SUBS
, MTL_ITEM_LOCATIONS_KFV LOCS
WHERE SUBS.ORGANIZATION_ID = LOCS.ORGANIZATION_ID
AND SUBS.SUBINVENTORY_CODE = LOCS.SUBINVENTORY_CODE UNION ALL SELECT FND_LV.LOOKUP_CODE ID
, FND_LV.MEANING VALUE
, NULL SUB_ORG_CODE
, NULL LOCATOR_ID
, NULL SUBINVENTORY_CODE
, NULL ORGANIZATION_ID
FROM FND_LOOKUPS FND_LV
WHERE FND_LV.LOOKUP_TYPE = 'OPI_DBI_SUBINV'
AND FND_LV.LOOKUP_CODE = '-1'