APPS.ARP_PROCESS_HEADER dependencies on RA_CUSTOMER_TRX_LINES

Line 696: l_line_rec ra_customer_trx_lines%rowtype;

692: PROCEDURE reverse_revrec_effect (
693: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
694: ) IS
695:
696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
698: BEGIN
699:
700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

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

803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
806: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
807: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
808: p_row_id OUT NOCOPY rowid,
809: p_status OUT NOCOPY varchar2,
810: p_receivable_ccid IN gl_code_combinations.code_combination_id%type
811: DEFAULT NULL,

Line 1082: ra_customer_trx_lines.initial_customer_trx_line_id%type

1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1081: p_initial_customer_trx_line_id IN
1082: ra_customer_trx_lines.initial_customer_trx_line_id%type
1083: default null,
1084: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1085: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1086: p_term_in_use_flag IN varchar2,

Line 1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;

1102: l_dispute_changed_flag boolean;
1103: l_cust_trx_type_changed_flag boolean;
1104:
1105: l_initial_customer_trx_line_id
1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;

Line 1110: l_line_rec ra_customer_trx_lines%rowtype;

1106: ra_customer_trx_lines.initial_customer_trx_line_id%type;
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1112:
1113: l_old_trx_rec ra_customer_trx%rowtype;
1114:

Line 1348: FROM ra_customer_trx_lines

1344: THEN
1345: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1346: BEGIN
1347: Select 'X' INTO l_dummy_flag
1348: FROM ra_customer_trx_lines
1349: WHERE customer_trx_id = p_customer_trx_id
1350: AND rownum = 1;
1351:
1352: arp_ctl_pkg.set_to_dummy( l_line_rec );

Line 1525: -- update ra_customer_trx_lines.initial_customer_trx_line_id

1521: AND
1522: nvl(p_trx_rec.initial_customer_trx_id, 0) <> pg_number_dummy)
1523: )
1524: THEN
1525: -- update ra_customer_trx_lines.initial_customer_trx_line_id
1526: IF (p_trx_rec.initial_customer_trx_id IS NOT NULL
1527: AND
1528: p_initial_customer_trx_line_id IS NULL)
1529: THEN

Line 1533: FROM ra_customer_trx_lines ctl

1529: THEN
1530: BEGIN
1531: SELECT customer_trx_line_id
1532: INTO l_initial_customer_trx_line_id
1533: FROM ra_customer_trx_lines ctl
1534: WHERE ctl.customer_trx_id = p_trx_rec.initial_customer_trx_id
1535: AND ctl.line_type = 'LINE';
1536: END;
1537: ELSE

Line 1761: from ra_customer_trx_lines ctl,

1757:
1758: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1759: CURSOR cont_cursor IS
1760: select alc.customer_trx_line_id
1761: from ra_customer_trx_lines ctl,
1762: ar_line_conts alc
1763: where
1764: ctl.customer_trx_id = p_customer_trx_id
1765: and ctl.customer_trx_line_id = alc.customer_trx_line_id

Line 2262: ra_customer_trx_lines.customer_trx_line_id%type;

2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context

Line 2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;

2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;

Line 2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;

2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1

Line 2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;

2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;

Line 2267: ra_customer_trx_lines.interface_line_context%type;

2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;

Line 2269: ra_customer_trx_lines.interface_line_attribute1%type;

2265: l_ctl_commitment_inv_item_id ra_customer_trx_lines.inventory_item_id%type;
2266: l_interface_line_context
2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;

Line 2271: ra_customer_trx_lines.interface_line_attribute2%type;

2267: ra_customer_trx_lines.interface_line_context%type;
2268: l_interface_line_attribute1
2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;

Line 2273: ra_customer_trx_lines.interface_line_attribute3%type;

2269: ra_customer_trx_lines.interface_line_attribute1%type;
2270: l_interface_line_attribute2
2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;

Line 2275: ra_customer_trx_lines.interface_line_attribute4%type;

2271: ra_customer_trx_lines.interface_line_attribute2%type;
2272: l_interface_line_attribute3
2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;

Line 2277: ra_customer_trx_lines.interface_line_attribute5%type;

2273: ra_customer_trx_lines.interface_line_attribute3%type;
2274: l_interface_line_attribute4
2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;

Line 2279: ra_customer_trx_lines.interface_line_attribute6%type;

2275: ra_customer_trx_lines.interface_line_attribute4%type;
2276: l_interface_line_attribute5
2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;

Line 2281: ra_customer_trx_lines.interface_line_attribute7%type;

2277: ra_customer_trx_lines.interface_line_attribute5%type;
2278: l_interface_line_attribute6
2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;

Line 2283: ra_customer_trx_lines.interface_line_attribute8%type;

2279: ra_customer_trx_lines.interface_line_attribute6%type;
2280: l_interface_line_attribute7
2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;

Line 2285: ra_customer_trx_lines.interface_line_attribute9%type;

2281: ra_customer_trx_lines.interface_line_attribute7%type;
2282: l_interface_line_attribute8
2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;

Line 2287: ra_customer_trx_lines.interface_line_attribute10%type;

2283: ra_customer_trx_lines.interface_line_attribute8%type;
2284: l_interface_line_attribute9
2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;

Line 2289: ra_customer_trx_lines.interface_line_attribute11%type;

2285: ra_customer_trx_lines.interface_line_attribute9%type;
2286: l_interface_line_attribute10
2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;

Line 2291: ra_customer_trx_lines.interface_line_attribute12%type;

2287: ra_customer_trx_lines.interface_line_attribute10%type;
2288: l_interface_line_attribute11
2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;

Line 2293: ra_customer_trx_lines.interface_line_attribute13%type;

2289: ra_customer_trx_lines.interface_line_attribute11%type;
2290: l_interface_line_attribute12
2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;

Line 2295: ra_customer_trx_lines.interface_line_attribute14%type;

2291: ra_customer_trx_lines.interface_line_attribute12%type;
2292: l_interface_line_attribute13
2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;

Line 2297: ra_customer_trx_lines.interface_line_attribute15%type;

2293: ra_customer_trx_lines.interface_line_attribute13%type;
2294: l_interface_line_attribute14
2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;

Line 2299: ra_customer_trx_lines.attribute_category%type;

2295: ra_customer_trx_lines.interface_line_attribute14%type;
2296: l_interface_line_attribute15
2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;

Line 2301: ra_customer_trx_lines.attribute1%type;

2297: ra_customer_trx_lines.interface_line_attribute15%type;
2298: l_attribute_category
2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;

Line 2303: ra_customer_trx_lines.attribute2%type;

2299: ra_customer_trx_lines.attribute_category%type;
2300: l_attribute1
2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;

Line 2305: ra_customer_trx_lines.attribute3%type;

2301: ra_customer_trx_lines.attribute1%type;
2302: l_attribute2
2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;

Line 2307: ra_customer_trx_lines.attribute4%type;

2303: ra_customer_trx_lines.attribute2%type;
2304: l_attribute3
2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;

Line 2309: ra_customer_trx_lines.attribute5%type;

2305: ra_customer_trx_lines.attribute3%type;
2306: l_attribute4
2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;

Line 2311: ra_customer_trx_lines.attribute6%type;

2307: ra_customer_trx_lines.attribute4%type;
2308: l_attribute5
2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;

Line 2313: ra_customer_trx_lines.attribute7%type;

2309: ra_customer_trx_lines.attribute5%type;
2310: l_attribute6
2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;

Line 2315: ra_customer_trx_lines.attribute8%type;

2311: ra_customer_trx_lines.attribute6%type;
2312: l_attribute7
2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;

Line 2317: ra_customer_trx_lines.attribute9%type;

2313: ra_customer_trx_lines.attribute7%type;
2314: l_attribute8
2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;

Line 2319: ra_customer_trx_lines.attribute10%type;

2315: ra_customer_trx_lines.attribute8%type;
2316: l_attribute9
2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;

Line 2321: ra_customer_trx_lines.attribute11%type;

2317: ra_customer_trx_lines.attribute9%type;
2318: l_attribute10
2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;

Line 2323: ra_customer_trx_lines.attribute12%type;

2319: ra_customer_trx_lines.attribute10%type;
2320: l_attribute11
2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;

Line 2325: ra_customer_trx_lines.attribute13%type;

2321: ra_customer_trx_lines.attribute11%type;
2322: l_attribute12
2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;

Line 2327: ra_customer_trx_lines.attribute14%type;

2323: ra_customer_trx_lines.attribute12%type;
2324: l_attribute13
2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;

Line 2329: ra_customer_trx_lines.attribute15%type;

2325: ra_customer_trx_lines.attribute13%type;
2326: l_attribute14
2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference

Line 2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;

2327: ra_customer_trx_lines.attribute14%type;
2328: l_attribute15
2329: ra_customer_trx_lines.attribute15%type;
2330: l_default_ussgl_trx_code
2331: ra_customer_trx_lines.default_ussgl_transaction_code%type;
2332: l_ct_prev_trx_number ra_customer_trx.trx_number%type;
2333: l_ct_prev_trx_reference
2334: ra_customer_trx.interface_header_attribute1%type;
2335: l_ct_prev_inv_currency_code

Line 2367: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;

2363: l_ct_prev_post_to_gl_flag
2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2365: l_al_cm_reason_meaning ar_lookups.meaning%type;
2366: l_ct_prev_rowid rowid;
2367: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2368: l_commit_memo_line_desc ar_memo_lines.description%type;
2369:
2370: BEGIN
2371:

Line 2466: ra_customer_trx_lines ctl_commit

2462: l_gd_commitment_gl_date,
2463: l_ctl_commitment_inv_item_id
2464: FROM ra_customer_trx ct_commit,
2465: ra_cust_trx_line_gl_dist gd_commit,
2466: ra_customer_trx_lines ctl_commit
2467: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2468: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2469: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2470: AND 'REC' = gd_commit.account_class(+)

Line 2564: FROM ra_customer_trx_lines ctl_commit

2560: l_attribute14,
2561: l_attribute15,
2562: l_default_ussgl_trx_code,
2563: l_commit_memo_line_id
2564: FROM ra_customer_trx_lines ctl_commit
2565: WHERE ctl_commit.customer_trx_id = p_customer_trx_id
2566: AND 1 = ctl_commit.line_number
2567: AND 'LINE' = ctl_commit.line_type;
2568: