APPS.ARP_REVENUE_ASSIGNMENTS dependencies on AR_REVENUE_ASSIGNMENTS_GT

Line 10: | This procedure populates ar_revenue_assignments_gt (a global temporary

6: /* ==================================================================================
7: | PROCEDURE build_for_credit
8: |
9: | DESCRIPTION
10: | This procedure populates ar_revenue_assignments_gt (a global temporary
11: | table) with rows from ar_revenue_assignments (the view). In 11i apps,
12: | the CBO seems to have a lot of trouble with any sql containing this
13: | view. So this is an effort to offload that work to a separate
14: | sql step.

Line 73: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT

69: THEN
70: arp_standard.debug('arp_revenue_assignments - using request_id');
71: END IF;
72:
73: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
74: (SESSION_ID,
75: CUSTOMER_TRX_LINE_ID,
76: COMPLETE_FLAG,
77: ACCOUNT_CLASS,

Line 143: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT

139: THEN
140: arp_standard.debug('arp_revenue_assignments - using line_id');
141: END IF;
142:
143: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
144: (SESSION_ID,
145: CUSTOMER_TRX_LINE_ID,
146: COMPLETE_FLAG,
147: ACCOUNT_CLASS,

Line 210: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT

206: THEN
207: arp_standard.debug('arp_revenue_assignments - using trx_id');
208: END IF;
209:
210: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
211: (SESSION_ID,
212: CUSTOMER_TRX_LINE_ID,
213: COMPLETE_FLAG,
214: ACCOUNT_CLASS,

Line 278: UPDATE ar_revenue_assignments_gt ragt

274: column for use in prorating credits */
275: IF p_use_inv_acctg = 'Y'
276: THEN
277: /* 10144015 - changed from gl_date to original_gl_date */
278: UPDATE ar_revenue_assignments_gt ragt
279: SET pprr_amount =
280: (SELECT Sum(ilgd.amount)
281: FROM ra_customer_trx_lines il,
282: ra_cust_trx_line_gl_dist ilgd,

Line 309: arp_standard.debug('DUMP of ar_revenue_assignments_gt ');

305: END IF;
306: END IF;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_standard.debug('DUMP of ar_revenue_assignments_gt ');
310: DECLARE
311: CURSOR c01 IS
312: SELECT
313: SESSION_ID,

Line 326: FROM AR_REVENUE_ASSIGNMENTS_GT

322: SET_OF_BOOKS_ID,
323: PERIOD_TYPE,
324: MAX_REGULAR_PERIOD_LENGTH,
325: PPRR_AMOUNT
326: FROM AR_REVENUE_ASSIGNMENTS_GT
327: WHERE session_id = p_session_id
328: ORDER BY CUSTOMER_TRX_LINE_ID, PERIOD_NUMBER;
329: i NUMBER := 1;
330: BEGIN