1228: SELECT APPLICATION_COLUMN_NAME,
1229: ffs.FLEX_VALUE_SET_ID,
1230: ffv.VALIDATION_TYPE
1231: FROM FND_ID_FLEX_SEGMENTS ffs,
1232: FND_FLEX_VALUE_SETS ffv
1233: WHERE APPLICATION_ID = 401 -- 'INV'
1234: AND ID_FLEX_CODE = 'MTLL'
1235: AND ID_FLEX_NUM = 101 -- 'STOCK_LOCATORS'
1236: AND ENABLED_FLAG = 'Y'
1644: SELECT APPLICATION_COLUMN_NAME,
1645: ffs.FLEX_VALUE_SET_ID,
1646: ffv.VALIDATION_TYPE
1647: FROM FND_ID_FLEX_SEGMENTS ffs,
1648: FND_FLEX_VALUE_SETS ffv
1649: WHERE APPLICATION_ID = 401 -- 'INV'
1650: AND ID_FLEX_CODE = 'MTLL'
1651: AND ID_FLEX_NUM = 101 -- 'STOCK_LOCATORS'
1652: AND ENABLED_FLAG = 'Y'