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_ID_FLEX_SEGMENTS

Line 401: FND_ID_FLEX_SEGMENTS fifs

397: if l_PROJECT_SOURCE='COA' and l_PROJECT_NUMBER is not null then
398: select count(*)
399: into l_count
400: from FND_FLEX_VALUES ffv,
401: FND_ID_FLEX_SEGMENTS fifs
402: where ffv.flex_value_set_id=fifs.flex_value_set_id
403: and fifs.id_flex_code='GL#'
404: and fifs.id_flex_num=l_coa
405: and (fifs.application_column_name =(select coa_segment

Line 1526: FROM Fnd_Id_Flex_Segments Fifs,

1522:
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

Line 1543: FROM Fnd_Id_Flex_Segments Fifs,

1539:
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

Line 1587: FROM Fnd_Id_Flex_Segments Fifs,

1583:
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

Line 1639: FROM Fnd_Id_Flex_Segments Fifs,

1635: ---jogen
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

Line 2153: FROM Fnd_Id_Flex_Segments Fifs,

2149:
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

Line 2169: FROM Fnd_Id_Flex_Segments Fifs,

2165: AND Led.Ledger_Id = l_ledger_id;
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

Line 2185: FROM Fnd_Id_Flex_Segments Fifs,

2181: AND Led.Ledger_Id = l_ledger_id;
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

Line 2433: FND_ID_FLEX_SEGMENTS fifs

2429: elsif l_project_source='COA'then
2430: select flex_value_id
2431: into l_project_id
2432: from FND_FLEX_VALUES ffv,
2433: FND_ID_FLEX_SEGMENTS fifs
2434: where ffv.flex_value_set_id=fifs.flex_value_set_id
2435: and fifs.id_flex_code='GL#'
2436: and fifs.id_flex_num=l_coa
2437: and (fifs.application_column_name =(select coa_segment