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_LINES

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 792: v_credit_amount gl_je_lines.entered_dr%TYPE;

788: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE;
789: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
790: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
791: v_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
792: v_credit_amount gl_je_lines.entered_dr%TYPE;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;
794: v_cc_id gl_je_lines.code_combination_id%TYPE;
795: v_n_segments NUMBER;
796: -- a_segments fnd_flex_ext.SegmentArray;

Line 793: v_debit_amount gl_je_lines.entered_cr%TYPE;

789: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
790: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
791: v_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
792: v_credit_amount gl_je_lines.entered_dr%TYPE;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;
794: v_cc_id gl_je_lines.code_combination_id%TYPE;
795: v_n_segments NUMBER;
796: -- a_segments fnd_flex_ext.SegmentArray;
797: v_boolean BOOLEAN;

Line 794: v_cc_id gl_je_lines.code_combination_id%TYPE;

790: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
791: v_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
792: v_credit_amount gl_je_lines.entered_dr%TYPE;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;
794: v_cc_id gl_je_lines.code_combination_id%TYPE;
795: v_n_segments NUMBER;
796: -- a_segments fnd_flex_ext.SegmentArray;
797: v_boolean BOOLEAN;
798: c_reference1 gl_interface.reference1%TYPE;

Line 801: v_invoice_id gl_je_lines.reference_4%TYPE;

797: v_boolean BOOLEAN;
798: c_reference1 gl_interface.reference1%TYPE;
799: v_tc_id gl_interface.reference1%TYPE;
800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;
804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;

Line 806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;

802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%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;

Line 807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;

803: v_period_start_date gl_period_statuses.start_date%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:

Line 893: -- Find the gl_je_lines records that are associated with the

889: SELECT gl_interface_control_s.NEXTVAL
890: INTO x_group_id
891: FROM dual;
892:
893: -- Find the gl_je_lines records that are associated with the
894: -- treasury_confirmation_id that is being backed out.
895:
896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 1085: gl_je_lines gjl

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
1089: AND gjh.je_category = 'Treasury Confirmation'

Line 1118: gl_je_lines gjl,

1114: gjh.currency_code,
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

Line 1221: -- Find the gl_je_lines records that are associated with the

1217: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'l_group_id is ' || l_group_id);
1218: END IF;
1219: END IF;
1220:
1221: -- Find the gl_je_lines records that are associated with the
1222: -- check_id that is being backed out.
1223:
1224: IF (retcode = '0') THEN
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN