DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS

Line 2398: FROM ap_invoice_distributions_all aid

2394: SELECT aid.invoice_id,
2395: aid.distribution_line_number
2396: INTO l_reference_2,
2397: l_reference_8
2398: FROM ap_invoice_distributions_all aid
2399: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
2400: EXCEPTION
2401: WHEN NO_DATA_FOUND THEN
2402: log(l_module, 'No data found for distribution id(1) '

Line 2411: FROM ap_invoice_distributions_all aid

2407: SELECT aid.invoice_id,
2408: aid.distribution_line_number
2409: INTO l_reference_2,
2410: l_reference_8
2411: FROM ap_invoice_distributions_all aid
2412: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
2413: EXCEPTION
2414: WHEN NO_DATA_FOUND THEN
2415: log(l_module, 'No data found for distribution id(1a) '

Line 2427: ap_invoice_distributions_all aid,

2423: INTO l_reference_3,
2424: l_reference_4,
2425: l_reference_6
2426: FROM ap_payment_hist_dists aphd,
2427: ap_invoice_distributions_all aid,
2428: ap_invoice_payments_all aip
2429: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2430: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2431: AND aip.invoice_payment_id = aphd.invoice_payment_id;

Line 2530: ap_invoice_distributions_all aid,

2526: INTO l_reference_3,
2527: l_reference_4,
2528: l_reference_6
2529: FROM ap_payment_hist_dists aphd,
2530: ap_invoice_distributions_all aid,
2531: ap_invoice_payments_all aip
2532: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2533: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2534: AND aip.invoice_payment_id = aphd.invoice_payment_id;

Line 3344: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;

3340: l_check_date Date;
3341: l_inv_payment_id Number;
3342: l_gl_date Date;
3343: l_rec_public_law_code VARCHAR2(150);
3344: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3345: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3346: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3347: l_dummy_rev_exists VARCHAR2(1);
3348:

Line 3788: FROM ap_invoice_distributions a

3784: BEGIN
3785: l_parent_reversal_id := NULL;
3786: SELECT a.parent_reversal_id
3787: INTO l_parent_reversal_id
3788: FROM ap_invoice_distributions a
3789: WHERE a.invoice_id = p_reference2
3790: AND a.distribution_line_number = p_reference3;
3791: EXCEPTION
3792: WHEN NO_DATA_FOUND THEN