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.JA_CN_ITEMIZATION_INTERFACE dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 1527: Fnd_Segment_Attribute_Values Fsav,

1523:
1524: CURSOR c_Cost_Center IS
1525: SELECT Fsav.Application_Column_Name
1526: FROM Fnd_Id_Flex_Segments Fifs,
1527: Fnd_Segment_Attribute_Values Fsav,
1528: Gl_Ledgers Led
1529: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
1530: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
1531: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'

Line 1544: Fnd_Segment_Attribute_Values Fsav,

1540: --jogen
1541: CURSOR c_Segements IS
1542: SELECT Fsav.Application_Column_Name
1543: FROM Fnd_Id_Flex_Segments Fifs,
1544: Fnd_Segment_Attribute_Values Fsav,
1545: Gl_Ledgers Led
1546: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
1547: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
1548: AND Fsav.Segment_Attribute_Type = 'GL_GLOBAL'

Line 1588: Fnd_Segment_Attribute_Values Fsav,

1584: --get application column name of account segment
1585: SELECT Fsav.Application_Column_Name
1586: INTO l_Account_Column_Name
1587: FROM Fnd_Id_Flex_Segments Fifs,
1588: Fnd_Segment_Attribute_Values Fsav,
1589: Gl_Ledgers Led
1590: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
1591: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
1592: AND Fsav.Segment_Attribute_Type = 'GL_ACCOUNT'

Line 1640: Fnd_Segment_Attribute_Values Fsav,

1636: BEGIN
1637: SELECT Fsav.Application_Column_Name
1638: INTO l_Second_Track_Col_Name
1639: FROM Fnd_Id_Flex_Segments Fifs,
1640: Fnd_Segment_Attribute_Values Fsav,
1641: Gl_Ledgers Led
1642: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
1643: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
1644: AND Fsav.Segment_Attribute_Type = 'GL_SECONDARY_TRACKING'

Line 2154: Fnd_Segment_Attribute_Values Fsav,

2150: --get application column name of Company segment
2151: SELECT Fsav.Application_Column_Name
2152: INTO l_Company_Column_Name
2153: FROM Fnd_Id_Flex_Segments Fifs,
2154: Fnd_Segment_Attribute_Values Fsav,
2155: Gl_Ledgers Led
2156: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
2157: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
2158: AND Fsav.Segment_Attribute_Type = 'GL_BALANCING'

Line 2170: Fnd_Segment_Attribute_Values Fsav,

2166: --get application column name of account segment
2167: SELECT Fsav.Application_Column_Name
2168: INTO l_Account_Column_Name
2169: FROM Fnd_Id_Flex_Segments Fifs,
2170: Fnd_Segment_Attribute_Values Fsav,
2171: Gl_Ledgers Led
2172: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
2173: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
2174: AND Fsav.Segment_Attribute_Type = 'GL_ACCOUNT'

Line 2186: Fnd_Segment_Attribute_Values Fsav,

2182: --get application column name of cost center segment
2183: SELECT Fsav.Application_Column_Name
2184: into l_Cost_CRT_Column_Name
2185: FROM Fnd_Id_Flex_Segments Fifs,
2186: Fnd_Segment_Attribute_Values Fsav,
2187: Gl_Ledgers Led
2188: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
2189: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
2190: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'