APPS.AR_AGING_BUCKETS_PKG dependencies on AR_AGING_EXTRACT

Line 623: from ar_aging_extract ext,

619: DECODE(mfar.bal_segment_value,null,ext.bal_segment_value,
620: mfar.bal_segment_value) bal_segment_value,
621: ext.contact_name,
622: ext.contact_phone
623: from ar_aging_extract ext,
624: ( select mfar.*,
625: '||pg_accounting_flexfield||' sort_field1,
626: '||pg_acct_flex_bal_seg||' bal_segment_value
627: from ar_aging_mfar_extract mfar,

Line 684: from ar_aging_extract ext,

680: ext.invoice_type,
681: ext.cons_billing_number,
682: ext.contact_name,
683: ext.contact_phone
684: from ar_aging_extract ext,
685: ( select mfar.*,
686: '||pg_accounting_flexfield||' sort_field1,
687: '||pg_acct_flex_bal_seg||' bal_segment_value
688: from ar_aging_mfar_extract mfar,

Line 829: from ar_aging_extract ext

825: ext.amt_due_remaining )) bucket_6,
826: bal_segment_value,
827: ext.contact_name,
828: ext.contact_phone
829: from ar_aging_extract ext
830: where 1 = 1
831: '||l_filter_criteria||'
832: )
833: group by customer_id,

Line 881: from ar_aging_extract ext

877: invoice_type,
878: cons_billing_number,
879: contact_name,
880: contact_phone
881: from ar_aging_extract ext
882: where 1=1 '||l_filter_criteria;
883: END IF;
884: END IF;
885:

Line 1283: FROM ar_aging_extract

1279: FROM ar_aging_payment_schedules
1280: WHERE parent_request_id = pg_request_id;
1281:
1282: DELETE
1283: FROM ar_aging_extract
1284: WHERE parent_request_id = pg_request_id;
1285:
1286: DELETE
1287: FROM ar_aging_mfar_extract

Line 1918: insert into ar_aging_extract

1914: arp_standard.debug( 'p_qry_category :'||p_qry_category);
1915: END IF;
1916:
1917: l_insert_stmt := '
1918: insert into ar_aging_extract
1919: ( customer_id,
1920: customer_number,
1921: short_customer_name,
1922: sort_field1,

Line 2766: from ar_aging_extract ext,

2762: ra.event_id,
2763: ext.payment_schedule_id,
2764: ext.amt_due_remaining,
2765: 'RA_APPLIED_FROM' source_identifier
2766: from ar_aging_extract ext,
2767: ar_receivable_applications ra
2768: where ext.parent_request_id = pg_parent_request_id
2769: and ext.worker_id = pg_worker_id
2770: and ext.payment_schedule_id = ra.payment_schedule_id

Line 2784: from ar_aging_extract ext,

2780: ra.event_id,
2781: ext.payment_schedule_id,
2782: ext.amt_due_remaining,
2783: 'RA_APPLIED_TO' source_identifier
2784: from ar_aging_extract ext,
2785: ar_receivable_applications ra
2786: where ext.parent_request_id = pg_parent_request_id
2787: and ext.worker_id = pg_worker_id
2788: and ext.payment_schedule_id = ra.applied_payment_schedule_id

Line 2802: from ar_aging_extract ext,

2798: adj.event_id,
2799: ext.payment_schedule_id,
2800: ext.amt_due_remaining,
2801: 'ADJ' source_identifier
2802: from ar_aging_extract ext,
2803: ar_adjustments adj
2804: where ext.parent_request_id = pg_parent_request_id
2805: and ext.worker_id = pg_worker_id
2806: and ext.payment_schedule_id = adj.payment_schedule_id

Line 2820: from ar_aging_extract ext,

2816: ctlgd.event_id,
2817: ext.payment_schedule_id,
2818: ext.amt_due_remaining,
2819: 'CTLGD' source_identifier
2820: from ar_aging_extract ext,
2821: ar_payment_schedules ps,
2822: ra_cust_trx_line_gl_dist ctlgd
2823: where ext.parent_request_id = pg_parent_request_id
2824: and ext.worker_id = pg_worker_id