DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_ID_FLEX_SEGMENTS

Line 1226: FROM FND_ID_FLEX_SEGMENTS ffs,

1222: CURSOR CUR_SEG IS
1223: SELECT APPLICATION_COLUMN_NAME,
1224: ffs.FLEX_VALUE_SET_ID,
1225: ffv.VALIDATION_TYPE
1226: FROM FND_ID_FLEX_SEGMENTS ffs,
1227: FND_FLEX_VALUE_SETS ffv
1228: WHERE APPLICATION_ID = 401 -- 'INV'
1229: AND ID_FLEX_CODE = 'MTLL'
1230: AND ID_FLEX_NUM = 101 -- 'STOCK_LOCATORS'

Line 1642: FROM FND_ID_FLEX_SEGMENTS ffs,

1638: CURSOR CUR_SEG IS
1639: SELECT APPLICATION_COLUMN_NAME,
1640: ffs.FLEX_VALUE_SET_ID,
1641: ffv.VALIDATION_TYPE
1642: FROM FND_ID_FLEX_SEGMENTS ffs,
1643: FND_FLEX_VALUE_SETS ffv
1644: WHERE APPLICATION_ID = 401 -- 'INV'
1645: AND ID_FLEX_CODE = 'MTLL'
1646: AND ID_FLEX_NUM = 101 -- 'STOCK_LOCATORS'

Line 1840: FROM fnd_id_flex_segments ffs

1836: FUNCTION GET_LOCSEGS(p_concatenated_segments IN VARCHAR2)
1837: RETURN VARCHAR2 IS
1838: CURSOR cur_seg IS
1839: SELECT application_column_name
1840: FROM fnd_id_flex_segments ffs
1841: WHERE application_id = 401 -- 'INV'
1842: AND id_flex_code = 'MTLL'
1843: AND id_flex_num = 101 -- 'STOCK_LOCATORS'
1844: AND enabled_flag = 'Y'

Line 1934: FROM fnd_id_flex_segments ffs

1930: FUNCTION GET_PJM_LOCSEGS(p_concatenated_segments IN VARCHAR2)
1931: RETURN VARCHAR2 IS
1932: CURSOR cur_seg IS
1933: SELECT application_column_name
1934: FROM fnd_id_flex_segments ffs
1935: WHERE application_id = 401 -- 'INV'
1936: AND id_flex_code = 'MTLL'
1937: AND id_flex_num = 101 -- 'STOCK_LOCATORS'
1938: AND enabled_flag = 'Y'