APPS.ARP_PROCESS_HEADER dependencies on RA_CUSTOMER_TRX_LINES

Line 753: l_line_rec ra_customer_trx_lines%rowtype;

749: PROCEDURE reverse_revrec_effect (
750: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
751: ) IS
752:
753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
755: BEGIN
756:
757: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

Line 864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
864: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
865: p_row_id OUT NOCOPY rowid,
866: p_status OUT NOCOPY varchar2,
867: p_receivable_ccid IN gl_code_combinations.code_combination_id%type
868: DEFAULT NULL,

Line 1139: ra_customer_trx_lines.initial_customer_trx_line_id%type

1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1138: p_initial_customer_trx_line_id IN
1139: ra_customer_trx_lines.initial_customer_trx_line_id%type
1140: default null,
1141: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1142: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1143: p_term_in_use_flag IN varchar2,

Line 1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;

1159: l_dispute_changed_flag boolean;
1160: l_cust_trx_type_changed_flag boolean;
1161:
1162: l_initial_customer_trx_line_id
1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;

Line 1167: l_line_rec ra_customer_trx_lines%rowtype;

1163: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1169:
1170: l_old_trx_rec ra_customer_trx%rowtype;
1171:

Line 1405: FROM ra_customer_trx_lines

1401: THEN
1402: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1403: BEGIN
1404: Select 'X' INTO l_dummy_flag
1405: FROM ra_customer_trx_lines
1406: WHERE customer_trx_id = p_customer_trx_id
1407: AND rownum = 1;
1408:
1409: arp_ctl_pkg.set_to_dummy( l_line_rec );

Line 1605: -- update ra_customer_trx_lines.initial_customer_trx_line_id

1601: AND
1602: nvl(p_trx_rec.initial_customer_trx_id, 0) <> pg_number_dummy)
1603: )
1604: THEN
1605: -- update ra_customer_trx_lines.initial_customer_trx_line_id
1606: IF (p_trx_rec.initial_customer_trx_id IS NOT NULL
1607: AND
1608: p_initial_customer_trx_line_id IS NULL)
1609: THEN

Line 1613: FROM ra_customer_trx_lines ctl

1609: THEN
1610: BEGIN
1611: SELECT customer_trx_line_id
1612: INTO l_initial_customer_trx_line_id
1613: FROM ra_customer_trx_lines ctl
1614: WHERE ctl.customer_trx_id = p_trx_rec.initial_customer_trx_id
1615: AND ctl.line_type = 'LINE';
1616: END;
1617: ELSE

Line 1841: from ra_customer_trx_lines ctl,

1837:
1838: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1839: CURSOR cont_cursor IS
1840: select alc.customer_trx_line_id
1841: from ra_customer_trx_lines ctl,
1842: ar_line_conts alc
1843: where
1844: ctl.customer_trx_id = p_customer_trx_id
1845: and ctl.customer_trx_line_id = alc.customer_trx_line_id

Line 2342: ra_customer_trx_lines.customer_trx_line_id%type;

2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context

Line 2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;

Line 2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;

2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1

Line 2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;

2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;

Line 2347: ra_customer_trx_lines.interface_line_context%type;

2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;

Line 2349: ra_customer_trx_lines.interface_line_attribute1%type;

2345: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2346: l_interface_line_context
2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;

Line 2351: ra_customer_trx_lines.interface_line_attribute2%type;

2347: ra_customer_trx_lines.interface_line_context%type;
2348: l_interface_line_attribute1
2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;

Line 2353: ra_customer_trx_lines.interface_line_attribute3%type;

2349: ra_customer_trx_lines.interface_line_attribute1%type;
2350: l_interface_line_attribute2
2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;

Line 2355: ra_customer_trx_lines.interface_line_attribute4%type;

2351: ra_customer_trx_lines.interface_line_attribute2%type;
2352: l_interface_line_attribute3
2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;

Line 2357: ra_customer_trx_lines.interface_line_attribute5%type;

2353: ra_customer_trx_lines.interface_line_attribute3%type;
2354: l_interface_line_attribute4
2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;

Line 2359: ra_customer_trx_lines.interface_line_attribute6%type;

2355: ra_customer_trx_lines.interface_line_attribute4%type;
2356: l_interface_line_attribute5
2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;

Line 2361: ra_customer_trx_lines.interface_line_attribute7%type;

2357: ra_customer_trx_lines.interface_line_attribute5%type;
2358: l_interface_line_attribute6
2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;

Line 2363: ra_customer_trx_lines.interface_line_attribute8%type;

2359: ra_customer_trx_lines.interface_line_attribute6%type;
2360: l_interface_line_attribute7
2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;

Line 2365: ra_customer_trx_lines.interface_line_attribute9%type;

2361: ra_customer_trx_lines.interface_line_attribute7%type;
2362: l_interface_line_attribute8
2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;

Line 2367: ra_customer_trx_lines.interface_line_attribute10%type;

2363: ra_customer_trx_lines.interface_line_attribute8%type;
2364: l_interface_line_attribute9
2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;

Line 2369: ra_customer_trx_lines.interface_line_attribute11%type;

2365: ra_customer_trx_lines.interface_line_attribute9%type;
2366: l_interface_line_attribute10
2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;

Line 2371: ra_customer_trx_lines.interface_line_attribute12%type;

2367: ra_customer_trx_lines.interface_line_attribute10%type;
2368: l_interface_line_attribute11
2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;

Line 2373: ra_customer_trx_lines.interface_line_attribute13%type;

2369: ra_customer_trx_lines.interface_line_attribute11%type;
2370: l_interface_line_attribute12
2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;

Line 2375: ra_customer_trx_lines.interface_line_attribute14%type;

2371: ra_customer_trx_lines.interface_line_attribute12%type;
2372: l_interface_line_attribute13
2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;

Line 2377: ra_customer_trx_lines.interface_line_attribute15%type;

2373: ra_customer_trx_lines.interface_line_attribute13%type;
2374: l_interface_line_attribute14
2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;

Line 2379: ra_customer_trx_lines.attribute_category%type;

2375: ra_customer_trx_lines.interface_line_attribute14%type;
2376: l_interface_line_attribute15
2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;

Line 2381: ra_customer_trx_lines.attribute1%type;

2377: ra_customer_trx_lines.interface_line_attribute15%type;
2378: l_attribute_category
2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;

Line 2383: ra_customer_trx_lines.attribute2%type;

2379: ra_customer_trx_lines.attribute_category%type;
2380: l_attribute1
2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;

Line 2385: ra_customer_trx_lines.attribute3%type;

2381: ra_customer_trx_lines.attribute1%type;
2382: l_attribute2
2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;

Line 2387: ra_customer_trx_lines.attribute4%type;

2383: ra_customer_trx_lines.attribute2%type;
2384: l_attribute3
2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;

Line 2389: ra_customer_trx_lines.attribute5%type;

2385: ra_customer_trx_lines.attribute3%type;
2386: l_attribute4
2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;

Line 2391: ra_customer_trx_lines.attribute6%type;

2387: ra_customer_trx_lines.attribute4%type;
2388: l_attribute5
2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;

Line 2393: ra_customer_trx_lines.attribute7%type;

2389: ra_customer_trx_lines.attribute5%type;
2390: l_attribute6
2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;

Line 2395: ra_customer_trx_lines.attribute8%type;

2391: ra_customer_trx_lines.attribute6%type;
2392: l_attribute7
2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;

Line 2397: ra_customer_trx_lines.attribute9%type;

2393: ra_customer_trx_lines.attribute7%type;
2394: l_attribute8
2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;

Line 2399: ra_customer_trx_lines.attribute10%type;

2395: ra_customer_trx_lines.attribute8%type;
2396: l_attribute9
2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;

Line 2401: ra_customer_trx_lines.attribute11%type;

2397: ra_customer_trx_lines.attribute9%type;
2398: l_attribute10
2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;

Line 2403: ra_customer_trx_lines.attribute12%type;

2399: ra_customer_trx_lines.attribute10%type;
2400: l_attribute11
2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;

Line 2405: ra_customer_trx_lines.attribute13%type;

2401: ra_customer_trx_lines.attribute11%type;
2402: l_attribute12
2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;

Line 2407: ra_customer_trx_lines.attribute14%type;

2403: ra_customer_trx_lines.attribute12%type;
2404: l_attribute13
2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;

Line 2409: ra_customer_trx_lines.attribute15%type;

2405: ra_customer_trx_lines.attribute13%type;
2406: l_attribute14
2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference

Line 2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;

2407: ra_customer_trx_lines.attribute14%type;
2408: l_attribute15
2409: ra_customer_trx_lines.attribute15%type;
2410: l_default_ussgl_trx_code
2411: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2412: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2413: l_ct_prev_trx_reference
2414: ra_customer_trx.interface_header_attribute1%type;
2415: l_ct_prev_inv_currency_code

Line 2447: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;

2443: l_ct_prev_post_to_gl_flag
2444: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2445: l_al_cm_reason_meaning ar_lookups.meaning%type;
2446: l_ct_prev_rowid rowid;
2447: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2448: l_commit_memo_line_desc ar_memo_lines.description%type;
2449:
2450: BEGIN
2451:

Line 2546: ra_customer_trx_lines ctl_commit

2542: l_gd_commitment_gl_date,
2543: l_ctl_commitment_inv_item_id
2544: FROM ra_customer_trx ct_commit,
2545: ra_cust_trx_line_gl_dist gd_commit,
2546: ra_customer_trx_lines ctl_commit
2547: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2548: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2549: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2550: AND 'REC' = gd_commit.account_class(+)

Line 2644: FROM ra_customer_trx_lines ctl_commit

2640: l_attribute14,
2641: l_attribute15,
2642: l_default_ussgl_trx_code,
2643: l_commit_memo_line_id
2644: FROM ra_customer_trx_lines ctl_commit
2645: WHERE ctl_commit.customer_trx_id = p_customer_trx_id
2646: AND 1 = ctl_commit.line_number
2647: AND 'LINE' = ctl_commit.line_type;
2648: