DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_ID_FLEX_SEGMENTS

Line 1231: FROM FND_ID_FLEX_SEGMENTS ffs,

1227: CURSOR CUR_SEG IS
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'

Line 1647: FROM FND_ID_FLEX_SEGMENTS ffs,

1643: CURSOR CUR_SEG IS
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'

Line 1870: FROM fnd_id_flex_segments ffs

1866: FUNCTION GET_LOCSEGS(p_concatenated_segments IN VARCHAR2)
1867: RETURN VARCHAR2 IS
1868: CURSOR cur_seg IS
1869: SELECT application_column_name
1870: FROM fnd_id_flex_segments ffs
1871: WHERE application_id = 401 -- 'INV'
1872: AND id_flex_code = 'MTLL'
1873: AND id_flex_num = 101 -- 'STOCK_LOCATORS'
1874: AND enabled_flag = 'Y'

Line 1964: FROM fnd_id_flex_segments ffs

1960: FUNCTION GET_PJM_LOCSEGS(p_concatenated_segments IN VARCHAR2)
1961: RETURN VARCHAR2 IS
1962: CURSOR cur_seg IS
1963: SELECT application_column_name
1964: FROM fnd_id_flex_segments ffs
1965: WHERE application_id = 401 -- 'INV'
1966: AND id_flex_code = 'MTLL'
1967: AND id_flex_num = 101 -- 'STOCK_LOCATORS'
1968: AND enabled_flag = 'Y'