eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTOAPPLY_API dependencies on DUAL

Line 224: FROM DUAL;

220: BEGIN
221: IF p_reco_num = 1 AND NVL(g_prev_reco_num, -1) <> 1 THEN
222: SELECT ar_cash_recos_s.nextval
223: INTO l_reco_id
224: FROM DUAL;
225: g_next_reco_id := l_reco_id;
226: g_prev_reco_num := p_reco_num;
227: ELSIF p_reco_num = 1 AND g_prev_reco_num = 1 THEN
228: g_prev_reco_num := -1;

Line 1257: FROM DUAL

1253: AND ps.terms_sequence_number = NVL(ref.installment_reference,
1254: ps.terms_sequence_number)
1255: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1256: NVL(cr.pay_from_customer, ps.customer_id))
1257: FROM DUAL
1258: UNION ALL
1259: SELECT related_cust_account_id
1260: FROM hz_cust_acct_relate_all rel
1261: WHERE rel.cust_account_id = cr.pay_from_customer

Line 1503: FROM DUAL

1499: AND ps.payment_schedule_id > 0
1500: AND ps.status = 'OP'
1501: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1502: NVL(cr.pay_from_customer, ps.customer_id))
1503: FROM DUAL
1504: UNION ALL
1505: SELECT related_cust_account_id
1506: FROM hz_cust_acct_relate_all rel
1507: WHERE rel.cust_account_id = cr.pay_from_customer

Line 1748: FROM DUAL

1744: AND ps.payment_schedule_id > 0
1745: AND ps.status = 'OP'
1746: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1747: NVL(cr.pay_from_customer, ps.customer_id))
1748: FROM DUAL
1749: UNION ALL
1750: SELECT related_cust_account_id
1751: FROM hz_cust_acct_relate_all rel
1752: WHERE rel.cust_account_id = cr.pay_from_customer

Line 1992: FROM DUAL

1988: AND ps.payment_schedule_id > 0
1989: AND ps.status = 'OP'
1990: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1991: NVL(cr.pay_from_customer, ps.customer_id))
1992: FROM DUAL
1993: UNION ALL
1994: SELECT related_cust_account_id
1995: FROM hz_cust_acct_relate_all rel
1996: WHERE rel.cust_account_id = cr.pay_from_customer

Line 2237: FROM DUAL

2233: ps.terms_sequence_number)
2234: AND ps.payment_schedule_id > 0
2235: AND ps.customer_id IN (SELECT DECODE(:b_pay_unrelated_invoices_flag,''Y'', ps.customer_id,
2236: NVL(cr.pay_from_customer, ps.customer_id))
2237: FROM DUAL
2238: UNION ALL
2239: SELECT related_cust_account_id
2240: FROM hz_cust_acct_relate_all rel
2241: WHERE rel.cust_account_id = cr.pay_from_customer

Line 2496: FROM DUAL

2492: AND ps.payment_schedule_id > 0
2493: AND ps.status = 'OP'
2494: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2495: NVL(cr.pay_from_customer, ps.customer_id))
2496: FROM DUAL
2497: UNION ALL
2498: SELECT related_cust_account_id
2499: FROM hz_cust_acct_relate_all rel
2500: WHERE rel.cust_account_id = cr.pay_from_customer

Line 2717: FROM DUAL

2713: AND ps.payment_schedule_id > 0
2714: AND ps.status = 'OP'
2715: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2716: NVL(cr.pay_from_customer, ps.customer_id))
2717: FROM DUAL
2718: UNION ALL
2719: SELECT related_cust_account_id
2720: FROM hz_cust_acct_relate_all rel
2721: WHERE rel.cust_account_id = cr.pay_from_customer

Line 2965: FROM DUAL

2961: AND ps.terms_sequence_number = NVL(ref.installment_reference,
2962: ps.terms_sequence_number)
2963: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2964: NVL(cr.pay_from_customer, ps.customer_id))
2965: FROM DUAL
2966: UNION ALL
2967: SELECT related_cust_account_id
2968: FROM hz_cust_acct_relate_all rel
2969: WHERE rel.cust_account_id = cr.pay_from_customer

Line 4131: FROM dual;

4127: log('process_single_reco()+');
4128: END IF;
4129: SELECT ar_cash_recos_s.nextval
4130: INTO l_recommendation_id
4131: FROM dual;
4132: l_recommendation_reason := 'AR_AM_INV_THRESHOLD';
4133: l_use_matching_date := p_current_reco(1).use_matching_date;
4134: l_use_matching_amount := p_current_reco(1).use_matching_amount;
4135: l_ref_amount_applied := p_current_reco(1).ref_amount_applied;

Line 4475: FROM DUAL;

4471: SYSDATE,
4472: p_request_id,
4473: match_reason_code_arr(l_reco_line_index),
4474: discount_taken_earned_arr(l_reco_line_index)
4475: FROM DUAL;
4476: IF (PG_DEBUG IN ('Y', 'C')) THEN
4477: log('insert_recos()+');
4478: END IF;
4479: EXCEPTION