DBA Data[Home] [Help]

APPS.FV_DISB_IN_TRANSIT dependencies on AP_AE_LINES

Line 319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;

315: /*
316: v_amount ap_payment_distributions.amount%TYPE;
317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;

Line 320: v_amount ap_ae_lines_all.entered_dr%TYPE;

316: v_amount ap_payment_distributions.amount%TYPE;
317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;

Line 321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;

317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;

Line 323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;

319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:

Line 324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;

320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;

Line 325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;

321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;

Line 342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;

338: v_vendor_id po_vendors.vendor_id%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;

Line 343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;

339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:

Line 344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;

340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);

Line 345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;

341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);
349: seg_prompt VARCHAR2(25);

Line 346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;

342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);
349: seg_prompt VARCHAR2(25);
350: seg_value_set_name VARCHAR2(40);

Line 370: ap_ae_lines apd,

366: ac.check_id
367: FROM fv_treasury_confirmations ftc,
368: ap_checks ac,
369: ap_invoice_payments aip,
370: ap_ae_lines apd,
371: iby_payments_all ipa
372: WHERE ftc.treasury_confirmation_id = x_treasury_confirmation_id
373: AND ftc.payment_instruction_id = ipa.payment_instruction_id
374: AND ipa.payment_id = ac.payment_id