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_DISB_IN_TRANSIT dependencies on GL_JE_HEADERS

Line 35: FROM ap_checks ac, gl_je_lines gjl, gl_je_headers gjh

31: gjl.accounted_dr,gjl.accounted_cr,
32: gjl.entered_dr, gjl.entered_cr, gjl.code_combination_id,
33: gjl.ROWID,
34: gjl.reference_4
35: FROM ap_checks ac, gl_je_lines gjl, gl_je_headers gjh
36: WHERE ac.void_date IS NULL
37: AND gjl.reference_1 = TO_CHAR(v_treasury_confirmation_id)
38: AND ac.check_id = gjl.reference_3
39: AND gjh.je_header_id = gjl.je_header_id

Line 808: v_curr_con_type gl_je_headers.currency_conversion_type%TYPE;

804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;
807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;
808: v_curr_con_type gl_je_headers.currency_conversion_type%TYPE;
809: v_curr_con_rate gl_je_headers.currency_conversion_rate%TYPE;
810: v_curr_con_date ap_checks.exchange_date%TYPE;
811:
812: BEGIN

Line 809: v_curr_con_rate gl_je_headers.currency_conversion_rate%TYPE;

805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;
807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;
808: v_curr_con_type gl_je_headers.currency_conversion_type%TYPE;
809: v_curr_con_rate gl_je_headers.currency_conversion_rate%TYPE;
810: v_curr_con_date ap_checks.exchange_date%TYPE;
811:
812: BEGIN
813: -- Initialize variables

Line 1084: gl_je_headers gjh,

1080: AND apip.creation_date BETWEEN ftc.creation_date and ftc.last_update_date)
1081: )
1082: AND EXISTS (SELECT null
1083: FROM gl_ledgers_public_v glpv,
1084: gl_je_headers gjh,
1085: gl_je_lines gjl
1086: WHERE glpv.ledger_id = p_set_of_books_id
1087: --AND gjh.set_of_books_id = gsob.set_of_books_id
1088: AND gjh.ledger_id = glpv.ledger_id

Line 1119: gl_je_headers gjh

1115: gjl.reference_4 invoice_id,
1116: gjl.rowid gl_rowid
1117: FROM gl_ledgers_public_v glpv,
1118: gl_je_lines gjl,
1119: gl_je_headers gjh
1120: WHERE glpv.ledger_id = p_set_of_books_id
1121: AND gjh.ledger_id = glpv.ledger_id
1122: AND gjl.ledger_id = glpv.ledger_id
1123: AND gjh.je_category = 'Treasury Confirmation'