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 GL_LEDGERS

Line 1121: FROM Gl_Periods Gp, Gl_Ledgers Led

1117: where --legal_entity_id = P_LEGAL_ENTITY_ID and--this condition will be put the legal_consistent validation
1118: ledger_id = P_LEDGER_ID
1119: and period_name in(
1120: SELECT Gp.Period_Name
1121: FROM Gl_Periods Gp, Gl_Ledgers Led
1122: WHERE Led.Ledger_Id = p_Ledger_Id
1123: AND Led.Period_Set_Name = Gp.Period_Set_Name
1124: AND Led.Accounted_Period_Type = Gp.Period_Type
1125: AND Gp.Start_Date BETWEEN

Line 1299: ' ,gl_ledgers led' ||

1295: ' FROM gl_je_headers jeh' ||
1296: ' ,gl_je_lines jel' ||
1297: ' ,gl_code_combinations gcc' ||
1298: ' ,gl_periods gp' ||
1299: ' ,gl_ledgers led' ||
1300: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
1301: ' WHERE jeh.je_header_id = jel.je_header_id' ||
1302: ' AND jeh.status = ''P''' ||
1303: ' AND jeh.period_name = gp.period_name' ||

Line 1519: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl

1515: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%type;
1516:
1517: cursor c_Project_Option is
1518: SELECT Project_Source_Flag
1519: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl
1520: where ja.chart_of_accounts_id=gl.chart_of_accounts_id
1521: and gl.ledger_id=l_ledger_id;
1522:
1523:

Line 1528: Gl_Ledgers Led

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'
1532: AND Fsav.Attribute_Value = 'Y'

Line 1545: Gl_Ledgers Led

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'
1549: AND Fsav.Attribute_Value = 'Y'

Line 1581: from gl_ledgers led

1577: close c_Project_Option;
1578: --get application column name of company segment
1579: SELECT led.bal_seg_column_name
1580: INTO l_Company_Column_Name
1581: from gl_ledgers led
1582: where Led.Ledger_Id = l_Ledger_Id;
1583:
1584: --get application column name of account segment
1585: SELECT Fsav.Application_Column_Name

Line 1589: Gl_Ledgers Led

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'
1593: AND Fsav.Attribute_Value = 'Y'

Line 1625: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl

1621: IF l_Project_Option = 'COA' THEN
1622: --get application column name of project segment
1623: SELECT Coa_Segment
1624: INTO l_Project_Column_Name
1625: FROM Ja_Cn_Sub_Acc_Sources_All ja,gl_ledgers gl
1626: WHERE ja.Chart_Of_Accounts_Id =gl.Chart_Of_Accounts_Id
1627: and gl.ledger_id=l_ledger_id;
1628: l_Create_View_Sql := l_Create_View_Sql || 'gcc.' ||
1629: l_Project_Column_Name || ' project_number,';

Line 1641: Gl_Ledgers Led

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'
1645: AND Fsav.Attribute_Value = 'Y'

Line 1682: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||

1678: ' other_columns,';
1679: --jogen
1680: l_Create_View_Sql := l_Create_View_Sql ||
1681: 'to_number(null) project_id from gl_code_combinations gcc,' ||
1682: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||
1683: ' = gcc.chart_of_accounts_id';
1684:
1685: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||
1686: l_Create_View_Sql;

Line 1756: L_LEDGER_NAME GL_LEDGERS.NAME%TYPE;

1752: L_XML_PARAMETER XMLTYPE;
1753: L_XML_LINE XMLTYPE;
1754:
1755: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
1756: L_LEDGER_NAME GL_LEDGERS.NAME%TYPE;
1757: L_JOURNAL_GROUP JA_CN_ITEM_INTERFACE.JOURNAL_GROUP%TYPE;
1758: L_JE_LINE_NUM JA_CN_ITEM_INTERFACE.JE_LINE_NUM%TYPE;
1759: L_STATUS_CODE JA_CN_ITEM_INTERFACE.STATUS%TYPE;
1760: L_DESCRIPTION FND_LOOKUP_VALUES.DESCRIPTION%TYPE;

Line 1778: FROM Gl_Periods Gp, Gl_Ledgers Led

1774: AND LEDGER_ID = p_ledger_id
1775: AND STATUS IS NOT NULL
1776: AND period_name in(
1777: SELECT Gp.Period_Name
1778: FROM Gl_Periods Gp, Gl_Ledgers Led
1779: WHERE Led.Ledger_Id = p_Ledger_Id
1780: AND Led.Period_Set_Name = Gp.Period_Set_Name
1781: AND Led.Accounted_Period_Type = Gp.Period_Type
1782: AND Gp.Start_Date BETWEEN

Line 1826: FROM Gl_Periods Gp, Gl_Ledgers Led

1822: if P_PERIOD_FROM is null then
1823: --get the first period of current led
1824: SELECT Gp.Period_Name
1825: INTO l_period_from
1826: FROM Gl_Periods Gp, Gl_Ledgers Led
1827: WHERE Led.Ledger_Id = p_ledger_id
1828: AND Led.Period_Set_Name = Gp.Period_Set_Name
1829: AND Led.Accounted_Period_Type = Gp.Period_Type
1830: AND Gp.Start_Date IN

Line 1845: FROM gl_ledgers

1841: WHERE legal_entity_id=p_legal_entity_id;
1842:
1843: SELECT name
1844: INTO l_ledger_name
1845: FROM gl_ledgers
1846: WHERE ledger_id=p_ledger_id;
1847:
1848: --write the parameter infomation into variable l_xml_parameter and last into l_xml_report
1849: FND_FILE.put_line(FND_FILE.output,'');

Line 1990: FROM Gl_Periods Gp, Gl_Ledgers Led

1986: where status='U';
1987:
1988: CURSOR c_Period_Name IS
1989: SELECT Gp.Period_Name
1990: FROM Gl_Periods Gp, Gl_Ledgers Led
1991: WHERE Led.Ledger_Id = l_Ledger_Id
1992: AND Led.Period_Set_Name = Gp.Period_Set_Name
1993: AND Led.Accounted_Period_Type = Gp.Period_Type
1994: AND Gp.Start_Date BETWEEN

Line 2082: FROM Gl_Periods Gp, Gl_Ledgers Led

2078: if P_PERIOD_FROM is null then
2079: --get the first period of current led
2080: SELECT Gp.Period_Name
2081: INTO l_period_from
2082: FROM Gl_Periods Gp, Gl_Ledgers Led
2083: WHERE Led.Ledger_Id = l_ledger_id
2084: AND Led.Period_Set_Name = Gp.Period_Set_Name
2085: AND Led.Accounted_Period_Type = Gp.Period_Type
2086: AND Gp.Start_Date IN

Line 2147: FROM gl_ledgers

2143:
2144: --get coa of parameter ledger id.
2145: SELECT chart_of_accounts_id
2146: INTO l_coa
2147: FROM gl_ledgers
2148: WHERE ledger_id = P_LEDGER_ID;
2149:
2150: --get application column name of Company segment
2151: SELECT Fsav.Application_Column_Name

Line 2155: Gl_Ledgers Led

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'
2159: AND Fsav.Attribute_Value = 'Y'

Line 2171: Gl_Ledgers Led

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'
2175: AND Fsav.Attribute_Value = 'Y'

Line 2187: Gl_Ledgers Led

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'
2191: AND Fsav.Attribute_Value = 'Y'