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.FV_SF224_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;

90: l_alc_code VARCHAR2(12);
91: flex_num NUMBER ;
92: x_name VARCHAR2(100);
93:
94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;
95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;
97: l_document_number VARCHAR2(100);
98:

Line 95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

91: flex_num NUMBER ;
92: x_name VARCHAR2(100);
93:
94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;
95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;
97: l_document_number VARCHAR2(100);
98:
99: --Define variable to store the end date for the transaction period

Line 1891: gl_je_headers glh,

1887: glh.je_source,
1888: glh.je_category,
1889: glh.je_from_sla_flag
1890: FROM gl_je_batches glb,
1891: gl_je_headers glh,
1892: gl_je_lines gll,
1893: gl_code_combinations gcc,
1894: fv_report_definitions frd,
1895: fv_fund_parameters ffp,

Line 1978: gl_je_headers glh,

1974: glh.je_source,
1975: glh.je_category,
1976: glh.je_from_sla_flag
1977: FROM gl_je_batches glb,
1978: gl_je_headers glh,
1979: gl_je_lines gll,
1980: gl_code_combinations gcc,
1981: fv_report_definitions frd,
1982: fv_fund_parameters ffp,

Line 2092: gl_je_headers glh,

2088: glh.je_source,
2089: glh.je_category,
2090: glh.je_from_sla_flag
2091: FROM gl_je_batches glb,
2092: gl_je_headers glh,
2093: gl_je_lines gll,
2094: gl_code_combinations gcc,
2095: fv_report_definitions frd,
2096: fv_fund_parameters ffp,

Line 2184: gl_je_headers glh,

2180: glh.je_source,
2181: glh.je_category,
2182: glh.je_from_sla_flag
2183: FROM gl_je_batches glb,
2184: gl_je_headers glh,
2185: gl_je_lines gll,
2186: gl_code_combinations gcc,
2187: fv_report_definitions frd,
2188: fv_fund_parameters ffp,

Line 2298: gl_je_headers glh,

2294: glh.je_source,
2295: glh.je_category,
2296: glh.je_from_sla_flag
2297: FROM gl_je_batches glb,
2298: gl_je_headers glh,
2299: gl_je_lines gll,
2300: gl_code_combinations gcc,
2301: fv_report_definitions frd,
2302: fv_fund_parameters ffp,

Line 2411: gl_je_headers glh,

2407: glh.je_category,
2408: glh.je_from_sla_flag
2409:
2410: FROM gl_je_batches glb,
2411: gl_je_headers glh,
2412: gl_je_lines gll,
2413: gl_code_combinations gcc,
2414: fv_report_definitions frd,
2415: fv_fund_parameters ffp,

Line 2519: gl_je_headers glh,

2515: glh.je_source,
2516: glh.je_category,
2517: glh.je_from_sla_flag
2518: FROM gl_je_batches glb,
2519: gl_je_headers glh,
2520: gl_je_lines gll,
2521: gl_code_combinations gcc,
2522: fv_report_definitions frd,
2523: fv_fund_parameters ffp,

Line 2632: gl_je_headers glh,

2628: glh.je_source,
2629: glh.je_category,
2630: glh.je_from_sla_flag
2631: FROM gl_je_batches glb,
2632: gl_je_headers glh,
2633: gl_je_lines gll,
2634: gl_code_combinations gcc,
2635: fv_report_definitions frd,
2636: fv_fund_parameters ffp,

Line 2746: gl_je_headers glh,

2742: glh.je_source,
2743: glh.je_category,
2744: glh.je_from_sla_flag
2745: FROM gl_je_batches glb,
2746: gl_je_headers glh,
2747: gl_je_lines gll,
2748: gl_code_combinations gcc,
2749: fv_report_definitions frd,
2750: fv_fund_parameters ffp,

Line 3168: FROM gl_je_headers

3164: x_name := l_name;
3165: l_name := 'MANUAL';
3166: SELECT SUBSTR(name,1,50)
3167: INTO l_document_number
3168: FROM gl_je_headers
3169: WHERE je_header_id = l_je_header_id;
3170: END;
3171: IF l_reference_1 IS NULL AND l_reference_6 IS NULL Then -- ref1
3172: x_name := 'Blank Treasury confirmation Id' ;

Line 3210: FROM gl_je_headers

3206: COMMIT;
3207: -- Get document number
3208: SELECT SUBSTR(name,1,50)
3209: INTO l_document_number
3210: FROM gl_je_headers
3211: WHERE je_header_id = l_je_header_id;
3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

Line 3262: FROM gl_je_headers

3258: COMMIT;
3259: -- Get document number
3260: SELECT SUBSTR(name,1,50)
3261: INTO l_document_number
3262: FROM gl_je_headers
3263: WHERE je_header_id = l_je_header_id;
3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

Line 3312: FROM gl_je_headers

3308: WHERE invoice_id = TO_NUMBER(l_reference_2);
3309: EXCEPTION WHEN NO_DATA_FOUND THEN
3310: SELECT SUBSTR(name,1,50)
3311: INTO l_document_number
3312: FROM gl_je_headers
3313: WHERE je_header_id = l_je_header_id;
3314: END;
3315: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3316: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Document_Num => ' || l_document_number);

Line 3534: FROM gl_je_headers

3530: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3531: EXCEPTION WHEN NO_DATA_FOUND THEN
3532: SELECT SUBSTR(name,1,50)
3533: INTO l_document_number
3534: FROM gl_je_headers
3535: WHERE je_header_id = l_je_header_id;
3536: END;
3537:
3538: ELSIF(l_je_category = 'Treasury Confirmation' AND

Line 3550: FROM gl_je_headers

3546: EXCEPTION
3547: WHEN NO_DATA_FOUND THEN
3548: SELECT SUBSTR(name,1,50)
3549: INTO l_document_number
3550: FROM gl_je_headers
3551: WHERE je_header_id = l_je_header_id;
3552: END;
3553: IF l_reference_3 IS NULL then
3554: x_name := 'Blank Check Id ' ;

Line 3595: FROM gl_je_headers

3591: x_name := l_name;
3592: l_name := 'MANUAL';
3593: SELECT SUBSTR(name,1,50)
3594: INTO l_document_number
3595: FROM gl_je_headers
3596: WHERE je_header_id = l_je_header_id;
3597: END IF; -- source1
3598:
3599: ---------------------------------------------------------------------------

Line 5631: gl_je_headers gljh,

5627: /*
5628: Commented for bug 14022463
5629: AND EXISTS (SELECT 1
5630: FROM gl_je_lines gljl,
5631: gl_je_headers gljh,
5632: ap_invoice_distributions_all apid
5633: WHERE gljl.ledger_id = apid.set_of_books_id
5634: AND gljl.status = 'P'
5635: AND gljh.je_header_id = gljl.je_header_id

Line 5643: gl_je_headers gljh,

5639: AND gljl.reference_2 = TO_CHAR(api.invoice_id)
5640: UNION
5641: SELECT 1
5642: FROM gl_je_lines gljl,
5643: gl_je_headers gljh,
5644: gl_import_references glir,
5645: xla_ae_lines xal,
5646: xla_distribution_links xdl,
5647: ap_invoice_distributions_all apid