eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 809: -- (FND_SEGMENT_ATTRIBUTE_VALUES table)

805: -- Procedure
806: -- validate_seg_attribute_value
807: -- Purpose
808: -- Do the validation for one particular segment attribute
809: -- (FND_SEGMENT_ATTRIBUTE_VALUES table)
810: -- History
811: -- 10.09.2000 O Monnier Created.
812: --
813: PROCEDURE validate_seg_attribute_value(v_application_id IN NUMBER,

Line 874: FROM FND_SEGMENT_ATTRIBUTE_VALUES

870: --
871: IF (v_attribute_value = 'Y' AND v_unique_flag = 'Y') THEN
872: SELECT count(*)
873: INTO v_count
874: FROM FND_SEGMENT_ATTRIBUTE_VALUES
875: WHERE application_id = v_application_id
876: AND id_flex_code = v_id_flex_code
877: AND id_flex_num = v_id_flex_num
878: AND segment_attribute_type = v_segment_attribute_type

Line 1820: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav

1816: AND fs.id_flex_num = v_id_flex_num
1817: AND sat.application_id = v_application_id
1818: AND sat.id_flex_code = v_id_flex_code
1819: AND NOT EXISTS (SELECT 'Exist'
1820: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1821: WHERE sav.application_id = v_application_id
1822: AND sav.id_flex_code = v_id_flex_code
1823: AND sav.id_flex_num = v_id_flex_num
1824: AND sav.application_column_name = fs.application_column_name

Line 1840: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav,

1836: AND sat.application_id = v_application_id
1837: AND sat.id_flex_code = v_id_flex_code
1838: AND sat.required_flag = 'Y'
1839: AND NOT EXISTS (SELECT 'Exist'
1840: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav,
1841: FND_ID_FLEX_SEGMENTS fs
1842: WHERE sav.application_id = v_application_id
1843: AND sav.id_flex_code = v_id_flex_code
1844: AND sav.id_flex_num = v_id_flex_num

Line 1876: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav1,

1872: WHERE fs.application_id = v_application_id
1873: AND fs.id_flex_code = v_id_flex_code
1874: AND fs.id_flex_num = v_id_flex_num
1875: AND fs.application_column_name IN (SELECT sav1.application_column_name
1876: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav1,
1877: FND_SEGMENT_ATTRIBUTE_VALUES sav2
1878: WHERE sav1.application_id = v_application_id
1879: AND sav1.id_flex_code = v_id_flex_code
1880: AND sav1.id_flex_num = v_id_flex_num

Line 1877: FND_SEGMENT_ATTRIBUTE_VALUES sav2

1873: AND fs.id_flex_code = v_id_flex_code
1874: AND fs.id_flex_num = v_id_flex_num
1875: AND fs.application_column_name IN (SELECT sav1.application_column_name
1876: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav1,
1877: FND_SEGMENT_ATTRIBUTE_VALUES sav2
1878: WHERE sav1.application_id = v_application_id
1879: AND sav1.id_flex_code = v_id_flex_code
1880: AND sav1.id_flex_num = v_id_flex_num
1881: AND sav1.segment_attribute_type = 'GL_ACCOUNT'

Line 2091: FROM fnd_segment_attribute_values sav,

2087: v_id_flex_code,
2088: sav.segment_attribute_type,
2089: vat.value_attribute_type,
2090: sysdate
2091: FROM fnd_segment_attribute_values sav,
2092: fnd_value_attribute_types vat,
2093: fnd_id_flex_segments seg
2094: WHERE seg.application_id = v_application_id
2095: AND seg.id_flex_code = v_id_flex_code