APPS.FV_SLA_PROCESSING_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 283: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj

279: CURSOR cur_ar_rct_natseg_value (p_event_id NUMBER,
280: p_line_number NUMBER)
281: IS
282: SELECT to_number(glseg.ar_gl_natural_segment_value) rct_natseg_value
283: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj
284: WHERE trxobj.dist_code_combination_id = glseg.ar_gl_code_combination_id
285: AND trxobj.event_id = p_event_id
286: AND trxobj.line_number = p_line_number;
287:

Line 293: FROM ar_distributions_l_v ardist

289: CURSOR cur_ar_rct_dist_type (p_event_id NUMBER,
290: p_line_number NUMBER)
291: IS
292: SELECT dist_source_type
293: FROM ar_distributions_l_v ardist
294: WHERE ardist.event_id = p_event_id
295: AND ardist.line_number = p_line_number;
296:
297: l_ar_inv_cust_class ar_bill_to_customers_s_v.bill_customer_class_code%TYPE;

Line 298: l_ar_rct_dist_type ar_distributions_l_v.distribution_type%TYPE;

294: WHERE ardist.event_id = p_event_id
295: AND ardist.line_number = p_line_number;
296:
297: l_ar_inv_cust_class ar_bill_to_customers_s_v.bill_customer_class_code%TYPE;
298: l_ar_rct_dist_type ar_distributions_l_v.distribution_type%TYPE;
299: l_line_natseg_value NUMBER := 0;
300: l_inv_line_natseg_value NUMBER := 0;
301:
302: BEGIN

Line 2998: FROM ar_distributions_l_v dist, ar_cust_trx_lines_l_v trxobj

2994: /* Get the AR Cash Receipt Extract Line */
2995: CURSOR cur_ar_rct_extract_details (p_dist_source_type VARCHAR2) IS
2996: SELECT dist.event_id, dist.line_number, dist.dist_code_combination_id,
2997: trxobj.trx_line_dist_ccid
2998: FROM ar_distributions_l_v dist, ar_cust_trx_lines_l_v trxobj
2999: WHERE dist.dist_source_type = p_dist_source_type
3000: AND trxobj.event_id (+) = dist.event_id
3001: AND trxobj.line_number (+) = dist.line_number;
3002:

Line 3007: FROM ar_distributions_l_v dist,

3003:
3004: /* Get the AR Receipt Applied to Invoice Reveneue Accounts CCID */
3005: CURSOR cur_rct_app_trx_rev_natacct IS
3006: SELECT distinct trxobj.trx_line_dist_ccid
3007: FROM ar_distributions_l_v dist,
3008: ar_cust_trx_lines_l_v trxobj
3009: WHERE dist.dist_source_type = 'REC'
3010: AND trxobj.event_id = dist.event_id
3011: AND trxobj.line_number = dist.line_number;

Line 3022: FROM ar_distributions_l_v;

3018:
3019: /* Get the Miscellaneous Receipt Extract Detail */
3020: CURSOR cur_misc_rct_extract_details IS
3021: SELECT *
3022: FROM ar_distributions_l_v;
3023:
3024: /* Get the AR Cash Receipt Application to Transaction lines */
3025: CURSOR cur_app_to_trx_balseg_val (p_event_id NUMBER,
3026: p_line_number NUMBER)

Line 3039: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj

3035: CURSOR cur_ar_rct_balseg_value (p_event_id NUMBER,
3036: p_line_number NUMBER)
3037: IS
3038: SELECT glseg.ar_gl_balacing_segment_value rct_fund_value
3039: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj
3040: WHERE trxobj.dist_code_combination_id = glseg.ar_gl_code_combination_id
3041: AND trxobj.event_id = p_event_id
3042: AND trxobj.line_number = p_line_number;
3043: