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.IEX_DUNNING_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1535: from ar_payment_schedules_all

1531:
1532: --Added for bug 9550221 gnramasa 20th Apr 2010
1533: cursor c_get_acc_info_from_inv(p_cust_trx_id number) is
1534: select customer_id
1535: from ar_payment_schedules_all
1536: where customer_trx_id = p_cust_trx_id;
1537:
1538: begin
1539:

Line 4091: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4087:
4088: -- Start for the bug#8408162 by PNAVEENK on 7-4-2009
4089: cursor c_fully_promised_party(p_party_id number) is
4090: SELECT count(1)
4091: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4092: WHERE del.party_cust_id=p_party_id
4093: AND ps.payment_schedule_id = del.payment_schedule_id
4094: AND ps.status = 'OP'
4095: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 4104: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4100: group by pd.delinquency_id
4101: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
4102: cursor c_fully_promised_account(p_cust_account_id number) is
4103: SELECT count(1)
4104: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4105: WHERE del.cust_account_id=p_cust_account_id
4106: AND ps.payment_schedule_id = del.payment_schedule_id
4107: AND ps.status = 'OP'
4108: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 4117: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4113: group by pd.delinquency_id
4114: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
4115: cursor c_fully_promised_billto(p_site_use_id number) is
4116: SELECT count(1)
4117: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4118: WHERE del.customer_site_use_id= p_site_use_id
4119: AND ps.payment_schedule_id = del.payment_schedule_id
4120: AND ps.status = 'OP'
4121: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 4243: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca

4239: where dunning_plan_id = p_dunn_plan_id;
4240:
4241: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
4242: select nvl(sum(aps.acctd_amount_due_remaining),0)
4243: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca
4244: where dd.payment_schedule_id = aps.payment_schedule_id
4245: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4246: and aps.status='OP'
4247: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 4256: from ar_payment_schedules_all aps,hz_cust_accounts hzca

4252: and hzca.party_id = p_party_id;
4253:
4254: cursor c_cust_acct_cm_tot_amt_rem (p_party_id number,p_org_id number) is
4255: select nvl(sum(acctd_amount_due_remaining),0)
4256: from ar_payment_schedules_all aps,hz_cust_accounts hzca
4257: where aps.class IN ('CM','PMT')
4258: and aps.status = 'OP'
4259: and aps.customer_id = hzca.cust_account_id
4260: and aps.org_id= p_org_id

Line 6975: from ar_payment_schedules_all ps,

6971: --
6972: cursor c_amount (IN_ID number) is
6973: select nvl(ps.amount_due_remaining,0),
6974: nvl(ps.invoice_currency_code,'USD')
6975: from ar_payment_schedules_all ps,
6976: --iex_delinquencies_all del
6977: iex_delinquencies del
6978: where ps.payment_schedule_id (+)= del.payment_schedule_id
6979: and del.delinquency_id = in_id;

Line 7191: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

7187: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - '||l_score);
7188: -- Start for the bug#8408162 by PNAVEENK
7189: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Start Fully Promise Check');
7190: SELECT count(1) into l_fully_promised
7191: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
7192: WHERE del.delinquency_id= l_delinquency_id
7193: AND ps.payment_schedule_id = del.payment_schedule_id
7194: AND ps.status = 'OP'
7195: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 8021: from ar_payment_schedules_all ps,

8017: --
8018: cursor c_amount (IN_ID number) is
8019: select ps.amount_due_remaining,
8020: ps.invoice_currency_code
8021: from ar_payment_schedules_all ps,
8022: --iex_delinquencies_all del
8023: iex_delinquencies del
8024: where ps.payment_schedule_id (+)= del.payment_schedule_id
8025: and del.delinquency_id = in_id;

Line 9204: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca

9200: where dunning_id = p_dunning_id;
9201:
9202: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
9203: select nvl(sum(aps.acctd_amount_due_remaining),0)
9204: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca
9205: where dd.payment_schedule_id = aps.payment_schedule_id
9206: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
9207: and aps.status='OP'
9208: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 9217: from ar_payment_schedules_all aps,hz_cust_accounts hzca

9213: and hzca.party_id = p_party_id;
9214:
9215: cursor c_cust_acct_cm_tot_amt_rem (p_party_id number,p_org_id number) is
9216: select nvl(sum(acctd_amount_due_remaining),0)
9217: from ar_payment_schedules_all aps,hz_cust_accounts hzca
9218: where aps.class IN ('CM','PMT')
9219: and aps.status = 'OP'
9220: and aps.customer_id = hzca.cust_account_id
9221: and aps.org_id= p_org_id

Line 11228: from ar_payment_schedules_all ps,

11224: --
11225: cursor c_amount (IN_ID number) is
11226: select ps.amount_due_remaining,
11227: ps.invoice_currency_code
11228: from ar_payment_schedules_all ps,
11229: --iex_delinquencies_all del
11230: iex_delinquencies del
11231: where ps.payment_schedule_id (+)= del.payment_schedule_id
11232: and del.delinquency_id = in_id;

Line 12021: from ar_payment_schedules_all ps,

12017: --
12018: cursor c_amount (IN_ID number) is
12019: select ps.amount_due_remaining,
12020: ps.invoice_currency_code
12021: from ar_payment_schedules_all ps,
12022: --iex_delinquencies_all del
12023: iex_delinquencies del
12024: where ps.payment_schedule_id (+)= del.payment_schedule_id
12025: and del.delinquency_id = in_id;

Line 14405: from ar_payment_schedules_all

14401: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_object_id: ' || p_object_id);
14402:
14403: select customer_trx_id, payment_schedule_id
14404: into l_transaction_id, l_payment_schedule_id
14405: from ar_payment_schedules_all
14406: where customer_trx_id = p_object_id;
14407: EXCEPTION
14408: WHEN OTHERS THEN
14409: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' SQL stmt throws exception ');

Line 14785: from ar_payment_schedules_all

14781: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_object_id: ' || p_object_id);
14782:
14783: select customer_trx_id, payment_schedule_id
14784: into l_transaction_id, l_payment_schedule_id
14785: from ar_payment_schedules_all
14786: where customer_trx_id = p_object_id;
14787: EXCEPTION
14788: WHEN OTHERS THEN
14789: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' SQL stmt throws exception ');

Line 17539: from ar_payment_schedules_all ps,

17535: FUNCTION Party_currency_code(p_party_id NUMBER) RETURN VARCHAR2
17536: IS
17537: cursor c_amount (IN_ID number) is
17538: select ps.invoice_currency_code
17539: from ar_payment_schedules_all ps,
17540: iex_delinquencies del
17541: where ps.payment_schedule_id (+)= del.payment_schedule_id
17542: and del.party_cust_id = in_id;
17543: l_code VARCHAR2(15);

Line 17565: from ar_payment_schedules_all ps,

17561: FUNCTION acct_currency_code(p_account_id NUMBER) RETURN VARCHAR2
17562: IS
17563: cursor c_amount (IN_ID number) is
17564: select ps.invoice_currency_code
17565: from ar_payment_schedules_all ps,
17566: --iex_delinquencies_all del
17567: iex_delinquencies del
17568: where ps.payment_schedule_id (+)= del.payment_schedule_id
17569: and del.cust_account_id = in_id;

Line 17592: from ar_payment_schedules_all ps,

17588: FUNCTION site_currency_code(p_customer_site_use_id NUMBER) RETURN VARCHAR2
17589: IS
17590: cursor c_amount (IN_ID number) is
17591: select ps.invoice_currency_code
17592: from ar_payment_schedules_all ps,
17593: iex_delinquencies del
17594: where ps.payment_schedule_id (+)= del.payment_schedule_id
17595: and del.customer_site_use_id = in_id;
17596:

Line 17620: from ar_payment_schedules_all ps,

17616: FUNCTION party_amount_due_remaining(p_party_id NUMBER) RETURN NUMBER
17617: IS
17618: cursor c_amount (IN_ID number) is
17619: select sum(ps.acctd_amount_due_remaining)
17620: from ar_payment_schedules_all ps,
17621: iex_delinquencies del
17622: where ps.payment_schedule_id (+)= del.payment_schedule_id
17623: and del.party_cust_id = in_id;
17624: l_sum number;

Line 17646: from ar_payment_schedules_all ps,

17642: FUNCTION acct_amount_due_remaining(p_account_id NUMBER) RETURN NUMBER
17643: IS
17644: cursor c_amount (IN_ID number) is
17645: select sum(ps.acctd_amount_due_remaining)
17646: from ar_payment_schedules_all ps,
17647: --iex_delinquencies_all del
17648: iex_delinquencies del
17649: where ps.payment_schedule_id (+)= del.payment_schedule_id
17650: and del.cust_account_id = in_id;

Line 17673: from ar_payment_schedules_all ps,

17669: FUNCTION site_amount_due_remaining(p_customer_site_use_id NUMBER) RETURN NUMBER
17670: IS
17671: cursor c_amount (IN_ID number) is
17672: select sum(ps.acctd_amount_due_remaining)
17673: from ar_payment_schedules_all ps,
17674: iex_delinquencies del
17675: where ps.payment_schedule_id (+)= del.payment_schedule_id
17676: and del.customer_site_use_id = in_id;
17677: l_sum number;

Line 17703: from ar_payment_schedules_all ps,

17699: FUNCTION staged_dunn_amt_due_remaining(p_dunning_id number) RETURN NUMBER
17700: IS
17701: cursor c_amount (dunn_id number) is
17702: select sum(ps.acctd_amount_due_remaining)
17703: from ar_payment_schedules_all ps,
17704: iex_dunning_transactions dtrx
17705: where ps.payment_schedule_id = dtrx.payment_schedule_id
17706: and dtrx.dunning_id = dunn_id;
17707: l_sum number;

Line 17985: 'ar_payment_schedules_all aps ' ||

17981: 'iex_dunnings id, ' ||
17982: 'XDO_TEMPLATES_B xtb, ' ||
17983: 'XDO_TEMPLATES_TL xtvl, ' ||
17984: 'iex_delinquencies_all del, ' ||
17985: 'ar_payment_schedules_all aps ' ||
17986: 'where id.dunning_object_id = del.delinquency_id ' ||
17987: 'and del.payment_Schedule_id = aps.payment_Schedule_id ' ||
17988: 'and del.party_cust_id = p.party_id ' ||
17989: 'and ixr.xml_request_id (+) = id.xml_request_id ' ||