APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on RA_CUSTOMER_TRX

Line 16: FROM ar_payment_schedules arps, ra_customer_trx ract

12: BEGIN
13: Errcd := 0;
14: SELECT arps.customer_trx_id,ract.trx_date
15: INTO cust_trx_id,trans_date
16: FROM ar_payment_schedules arps, ra_customer_trx ract
17: WHERE arps.payment_schedule_id = pay_sched_id
18: AND ract.customer_trx_id = arps.customer_trx_id
19: AND rownum = row_number;
20:

Line 139: -- Get Global Attributes 1..7 from ra_customer_trx

135: Errcd := SQLCODE;
136: END get_interest_payment_date;
137:
138:
139: -- Get Global Attributes 1..7 from ra_customer_trx
140: PROCEDURE get_customer_interest_dtls (cust_trx_id IN NUMBER,
141: interest_type IN OUT NOCOPY VARCHAR2,
142: interest_rate_amount IN OUT NOCOPY NUMBER,
143: interest_period IN OUT NOCOPY NUMBER,

Line 162: FROM ra_customer_trx

158: SUBSTR (global_attribute6, 1, 15),
159: fnd_number.canonical_to_number(SUBSTR (global_attribute7, 1, 38))
160: INTO interest_type, interest_rate_amount, interest_period, interest_formula,
161: interest_grace_days, penalty_type, penalty_rate_amount
162: FROM ra_customer_trx
163: WHERE customer_trx_id = cust_trx_id
164: AND rownum = row_number;
165: EXCEPTION
166: WHEN OTHERS THEN

Line 182: ra_customer_trx ract,

178: INTO city
179: FROM ar_payment_schedules arps,
180: hz_cust_acct_sites ad,
181: hz_cust_site_uses hzsu,
182: ra_customer_trx ract,
183: -- ra_site_uses rasu,
184: hz_locations loc,
185: hz_party_sites pty
186: WHERE arps.payment_schedule_id = pay_sched_id

Line 326: FROM ra_customer_trx rct, ra_cust_trx_types rctt

322: BEGIN
323: Errcd := 0;
324: SELECT COUNT (rct.complete_flag)
325: INTO total_records
326: FROM ra_customer_trx rct, ra_cust_trx_types rctt
327: WHERE rct.complete_flag = 'Y'
328: AND NVL (rct.printing_count,0) = 0
329: AND NVL (rct.status_trx, 'VD') <> 'VD'
330: AND rctt.cust_trx_type_id = rct.cust_trx_type_id

Line 531: FROM ra_customer_trx_lines

527: SELECT TO_NUMBER (global_attribute11),
528: TO_NUMBER (global_attribute12)
529: INTO base_amt,
530: base_rate
531: FROM ra_customer_trx_lines
532: WHERE customer_trx_line_id = cust_trx_id
533: AND rownum = row_number;
534: EXCEPTION
535: WHEN OTHERS THEN

Line 547: FROM ra_customer_trx

543: BEGIN
544: Errcd := 0;
545: SELECT global_attribute8
546: INTO iss_date
547: FROM ra_customer_trx
548: WHERE customer_trx_id = cust_trx_id
549: AND rownum = row_number;
550: EXCEPTION
551: WHEN OTHERS THEN

Line 566: FROM ra_customer_trx_all rct,

562: SELECT rct.status_trx,
563: rctt.type
564: INTO status,
565: typ_class
566: FROM ra_customer_trx_all rct,
567: ra_cust_trx_types_all rctt
568: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id
569: AND rct.customer_trx_id = cust_trx_id
570: AND rownum = row_number;

Line 849: FROM ra_customer_trx_lines

845:
846: BEGIN
847: SELECT count(*)
848: INTO p_warehouse_count
849: FROM ra_customer_trx_lines
850: WHERE customer_trx_id = p_customer_trx_id
851: AND line_type = 'LINE'
852: AND warehouse_id IS NULL
853: AND inventory_item_id IS NOT NULL;

Line 863: FROM ra_customer_trx_lines

859:
860: BEGIN
861: SELECT distinct warehouse_id
862: INTO p_warehouse_id
863: FROM ra_customer_trx_lines
864: WHERE customer_trx_id = p_customer_trx_id
865: AND line_type = 'LINE'
866: AND inventory_item_id IS NOT NULL
867: AND rownum = 1;

Line 919: ra_customer_trx ract,

915: state --Bug 2319552
916: FROM ar_payment_schedules arps,
917: hz_cust_acct_sites ad,
918: hz_cust_site_uses hzsu,
919: ra_customer_trx ract,
920: --ra_site_uses rasu,
921: hz_locations loc,
922: hz_party_sites pty
923: WHERE arps.payment_schedule_id = pay_sched_id