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.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_JE_LINES

Line 77: gl_je_lines gljl

73: 'SEGMENT28',glcc.segment28, 'SEGMENT29',glcc.segment29,
74: 'SEGMENT30',glcc.segment30, NULL) account_code
75: FROM gl_je_headers gljh,
76: gl_code_combinations glcc,
77: gl_je_lines gljl
78: WHERE gljl.status = 'P'
79: AND gljl.period_name = x_period
80: AND gljl.ledger_id = x_sobid
81: AND gljh.je_batch_id = NVL(x_batchid,gljh.je_batch_id)

Line 109: from gl_je_lines jl,

105: AND nvl(gljl.co_processed_flag, 'N') <> 'Y'
106: AND gljh.actual_flag = 'A'
107: AND gljh.currency_code <> 'STAT'
108: AND not exists (select 1 --filtering for intercompany lines created in GL -- Begin of bug10084267 fix
109: from gl_je_lines jl,
110: fnd_new_messages fnm
111: where fnm.message_name in ('PPOS0220', 'PPOS0221', 'PPOS0222', 'PPOS0243', 'PPOS0222_G','PPOSO275')
112: and fnm.application_id = 101 --bug 13355793
113: and language_code = USERENV('LANG')

Line 637: UPDATE gl_je_lines gljl

633: DELETE FROM jl_co_gl_trx jlcgt
634: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
635: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
636: ELSE */ -- Bug 8215616
637: UPDATE gl_je_lines gljl
638: SET co_processed_flag = 'Y'
639: WHERE gljl.je_header_id = p_journal_rec.je_header_id
640: AND gljl.je_line_num = p_journal_rec.je_line_num
641: AND EXISTS (SELECT 'Y'

Line 1215: UPDATE gl_je_lines gljl

1211: END;
1212:
1213: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1214:
1215: UPDATE gl_je_lines gljl
1216: SET co_processed_flag = 'N'
1217: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1218: AND gljl.je_line_num = p_journal_rec.je_line_num
1219: AND EXISTS (SELECT 'Y'

Line 1228: UPDATE gl_je_lines gljl

1224: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1225: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1226:
1227: ELSE
1228: UPDATE gl_je_lines gljl
1229: SET co_processed_flag = 'Y'
1230: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1231: AND gljl.je_line_num = p_journal_rec.je_line_num
1232: AND EXISTS (SELECT 'Y'

Line 1259: UPDATE gl_je_lines gljl

1255: NULL;
1256: END;
1257:
1258: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1259: UPDATE gl_je_lines gljl
1260: SET co_processed_flag = 'N'
1261: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1262: AND gljl.je_line_num = p_journal_rec.je_line_num
1263: AND EXISTS (SELECT 'Y'

Line 1492: UPDATE gl_je_lines gljl

1488: END;
1489:
1490: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1491: FND_FILE.PUT_LINE(FND_FILE.log,'Inside PO - 004.1');
1492: UPDATE gl_je_lines gljl
1493: SET co_processed_flag = 'N'
1494: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1495: AND gljl.je_line_num = p_journal_rec.je_line_num
1496: AND EXISTS (SELECT 'Y'

Line 1507: UPDATE gl_je_lines gljl

1503: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1504:
1505: ELSE
1506: FND_FILE.PUT_LINE(FND_FILE.log,'Inside PO - 004.2');
1507: UPDATE gl_je_lines gljl
1508: SET co_processed_flag = 'Y'
1509: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1510: AND gljl.je_line_num = p_journal_rec.je_line_num
1511: AND EXISTS (SELECT 'Y'

Line 1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;

1696: FROM gl_import_references glir
1697: WHERE glir.je_header_id = p_journal_rec.je_header_id
1698: AND glir.je_line_num = p_journal_rec.je_line_num;
1699:
1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1702: l_ent_dr gl_je_lines.entered_dr%TYPE;
1703: l_ent_cr gl_je_lines.entered_cr%TYPE;
1704: l_customer_num po_vendors.segment1%TYPE;

Line 1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;

1697: WHERE glir.je_header_id = p_journal_rec.je_header_id
1698: AND glir.je_line_num = p_journal_rec.je_line_num;
1699:
1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1702: l_ent_dr gl_je_lines.entered_dr%TYPE;
1703: l_ent_cr gl_je_lines.entered_cr%TYPE;
1704: l_customer_num po_vendors.segment1%TYPE;
1705: l_identifier_type VARCHAR2(30);

Line 1702: l_ent_dr gl_je_lines.entered_dr%TYPE;

1698: AND glir.je_line_num = p_journal_rec.je_line_num;
1699:
1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1702: l_ent_dr gl_je_lines.entered_dr%TYPE;
1703: l_ent_cr gl_je_lines.entered_cr%TYPE;
1704: l_customer_num po_vendors.segment1%TYPE;
1705: l_identifier_type VARCHAR2(30);
1706:

Line 1703: l_ent_cr gl_je_lines.entered_cr%TYPE;

1699:
1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1702: l_ent_dr gl_je_lines.entered_dr%TYPE;
1703: l_ent_cr gl_je_lines.entered_cr%TYPE;
1704: l_customer_num po_vendors.segment1%TYPE;
1705: l_identifier_type VARCHAR2(30);
1706:
1707: BEGIN

Line 1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;

1968: AND R.je_line_num = p_journal_rec.je_line_num
1969: AND et.event_type_code = aeh.event_type_code;
1970:
1971:
1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1974: l_ent_dr gl_je_lines.entered_dr%TYPE;
1975: l_ent_cr gl_je_lines.entered_cr%TYPE;
1976: l_customer_num po_vendors.segment1%TYPE;

Line 1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;

1969: AND et.event_type_code = aeh.event_type_code;
1970:
1971:
1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1974: l_ent_dr gl_je_lines.entered_dr%TYPE;
1975: l_ent_cr gl_je_lines.entered_cr%TYPE;
1976: l_customer_num po_vendors.segment1%TYPE;
1977: l_identifier_type VARCHAR2(30);

Line 1974: l_ent_dr gl_je_lines.entered_dr%TYPE;

1970:
1971:
1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1974: l_ent_dr gl_je_lines.entered_dr%TYPE;
1975: l_ent_cr gl_je_lines.entered_cr%TYPE;
1976: l_customer_num po_vendors.segment1%TYPE;
1977: l_identifier_type VARCHAR2(30);
1978: l_country_code varchar2(30);

Line 1975: l_ent_cr gl_je_lines.entered_cr%TYPE;

1971:
1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1974: l_ent_dr gl_je_lines.entered_dr%TYPE;
1975: l_ent_cr gl_je_lines.entered_cr%TYPE;
1976: l_customer_num po_vendors.segment1%TYPE;
1977: l_identifier_type VARCHAR2(30);
1978: l_country_code varchar2(30);
1979: l_branch_country_code varchar2(60);

Line 2220: UPDATE gl_je_lines gljl

2216: END;
2217:
2218: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
2219: FND_FILE.PUT_LINE(FND_FILE.log,'Stage 2.1');
2220: UPDATE gl_je_lines gljl
2221: SET co_processed_flag = 'N'
2222: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2223: AND gljl.je_line_num = p_journal_rec.je_line_num
2224: AND EXISTS (SELECT 'Y'

Line 2234: UPDATE gl_je_lines gljl

2230: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
2231: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
2232: ELSE
2233: FND_FILE.PUT_LINE(FND_FILE.log,'Stage2.2');
2234: UPDATE gl_je_lines gljl
2235: SET co_processed_flag = 'Y'
2236: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2237: AND gljl.je_line_num = p_journal_rec.je_line_num
2238: AND EXISTS (SELECT 'Y'

Line 2271: UPDATE gl_je_lines gljl

2267: END;
2268:
2269: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
2270: FND_FILE.PUT_LINE(FND_FILE.log,'Stage 4');
2271: UPDATE gl_je_lines gljl
2272: SET co_processed_flag = 'N'
2273: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2274: AND gljl.je_line_num = p_journal_rec.je_line_num
2275: AND EXISTS (SELECT 'Y'

Line 2484: UPDATE gl_je_lines gljl

2480: DELETE FROM jl_co_gl_trx jlcgt
2481: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
2482: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
2483: ELSE */ -- Bug 8215616
2484: UPDATE gl_je_lines gljl
2485: SET co_processed_flag = 'Y'
2486: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2487: AND gljl.je_line_num = p_journal_rec.je_line_num
2488: AND EXISTS (SELECT 'Y'

Line 2948: UPDATE gl_je_lines gljl

2944: END LOOP; -- UPDATE balances
2945:
2946: -- delete transactions
2947:
2948: UPDATE gl_je_lines gljl
2949: SET co_processed_flag = 'N'
2950: WHERE co_processed_flag = 'Y'
2951: AND status = 'P'
2952: AND EXISTS (SELECT 1

Line 3315: UPDATE gl_je_lines gljl

3311: --bug 8845393 Starts: Updating CO_PROCESSED_FLAG for Reversal Lines so that
3312: -- same record is NOT picked again if reversal process
3313: -- is run more than once for same period.
3314:
3315: UPDATE gl_je_lines gljl
3316: SET co_processed_flag = 'Y'
3317: WHERE gljl.je_header_id = reverse_rec_tbl(j_line).je_header_id
3318: AND gljl.je_line_num = reverse_rec_tbl(j_line).je_line_num
3319: AND EXISTS (SELECT 'Y'