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_UWQ_VIEW_PKG dependencies on IEX_PROMISE_DETAILS

Line 133: ' FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies_all del ' ||

129: IF p_party_id > 0 THEN
130: l_pro_clause := 'SELECT COUNT(1) ' ||
131: 'FROM (' ||
132: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
133: ' FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies_all del ' ||
134: ' WHERE ca.cust_account_id = pro.cust_account_id ' ||
135: ' AND pro.state = ''BROKEN_PROMISE'' ' ||
136: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
137: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003

Line 151: ' FROM iex_promise_details pro, hz_cust_accounts ca ' ||

147: ' AND ca.party_id = :party_id ' ||
148: ' AND del.org_id = :org_id ' ||
149: ' UNION ALL ' ||
150: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
151: ' FROM iex_promise_details pro, hz_cust_accounts ca ' ||
152: ' WHERE ca.cust_account_id = pro.cust_account_id ' ||
153: ' AND pro.state = ''BROKEN_PROMISE'' ' ||
154: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
155: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003

Line 169: ' FROM iex_promise_details pro, iex_delinquencies_all del ' ||

165: ELSIF p_cust_account_id > 0 THEN
166: l_pro_clause := 'SELECT COUNT(1) ' ||
167: 'FROM (' ||
168: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
169: ' FROM iex_promise_details pro, iex_delinquencies_all del ' ||
170: ' WHERE pro.delinquency_id = del.delinquency_id ' ||
171: ' AND pro.state = ''BROKEN_PROMISE'' ' ||
172: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
173: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003

Line 186: ' FROM iex_promise_details pro' ||

182: ' AND del.org_id = :org_id ' ||
183: --END-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status
184: ' UNION ALL ' ||
185: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
186: ' FROM iex_promise_details pro' ||
187: ' WHERE pro.state = ''BROKEN_PROMISE'' ' ||
188: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
189: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003
190: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency

Line 204: ' FROM iex_promise_details pro, iex_delinquencies_all del ' ||

200: ELSIF p_site_use_id > 0 THEN
201: l_pro_clause := 'SELECT COUNT(1) ' ||
202: 'FROM (' ||
203: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
204: ' FROM iex_promise_details pro, iex_delinquencies_all del ' ||
205: ' WHERE pro.state = ''BROKEN_PROMISE'' ' ||
206: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
207: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003
208: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency

Line 222: ' FROM iex_promise_details pro, okc_k_headers_b okch ' ||

218: ' AND del.org_id = :org_id ' ||
219: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise
220: ' UNION ALL ' ||
221: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
222: ' FROM iex_promise_details pro, okc_k_headers_b okch ' ||
223: ' WHERE pro.state = ''BROKEN_PROMISE'' ' ||
224: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
225: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003
226: ' AND pro.contract_id = okch.id ' ||

Line 571: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del

567: IS
568: CURSOR c_party_amt IS
569: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
570: -- SELECT SUM(amount_due_remaining)
571: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
572: -- WHERE pro.cust_account_id = ca.cust_account_id
573: -- AND ca.party_id = p_party_id
574: -- AND pro.status in ('COLLECTABLE', 'PENDING')
575: -- AND pro.state = 'BROKEN_PROMISE'

Line 582: FROM iex_promise_details pro, iex_delinquencies_all del

578: -- AND pro.delinquency_id = del.delinquency_id(+)
579: -- AND del.status(+) <> 'CURRENT';
580: SELECT SUM(amount_due_remaining)
581: FROM ( SELECT amount_due_remaining
582: FROM iex_promise_details pro, iex_delinquencies_all del
583: WHERE del.party_cust_id = p_party_id
584: AND pro.status in ('COLLECTABLE', 'PENDING')
585: AND pro.state = 'BROKEN_PROMISE'
586: AND pro.amount_due_remaining > 0

Line 593: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca

589: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
590: AND del.org_id = p_org_id
591: UNION ALL
592: SELECT amount_due_remaining
593: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
594: WHERE ca.cust_account_id = pro.cust_account_id
595: AND ca.party_id = p_party_id
596: AND pro.status in ('COLLECTABLE', 'PENDING')
597: AND pro.state = 'BROKEN_PROMISE'

Line 605: FROM iex_promise_details pro, iex_delinquencies_all del

601: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
602:
603: CURSOR c_acc_amt IS
604: SELECT SUM(amount_due_remaining)
605: FROM iex_promise_details pro, iex_delinquencies_all del
606: WHERE pro.cust_account_id = p_cust_account_id
607: AND pro.status in ('COLLECTABLE', 'PENDING')
608: AND pro.state = 'BROKEN_PROMISE'
609: AND pro.amount_due_remaining > 0

Line 623: -- FROM iex_promise_details pro, iex_delinquencies del

619:
620: CURSOR c_billto_amt IS
621: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
622: -- SELECT SUM(amount_due_remaining)
623: -- FROM iex_promise_details pro, iex_delinquencies del
624: -- WHERE del.customer_site_use_id = p_site_use_id
625: -- AND pro.status in ('COLLECTABLE', 'PENDING')
626: -- AND pro.state = 'BROKEN_PROMISE'
627: -- AND pro.amount_due_remaining > 0

Line 634: FROM iex_promise_details pro, iex_delinquencies_all del

630: -- AND del.status <> 'CURRENT';
631: -- AND del.status IN ('DELINQUENT', 'PREDELINQUENT');
632: SELECT SUM(amount_due_remaining)
633: FROM ( SELECT amount_due_remaining
634: FROM iex_promise_details pro, iex_delinquencies_all del
635: WHERE del.customer_site_use_id = p_site_use_id
636: AND pro.status in ('COLLECTABLE', 'PENDING')
637: AND pro.state = 'BROKEN_PROMISE'
638: AND pro.amount_due_remaining > 0

Line 645: FROM iex_promise_details pro, okc_k_headers_b okch

641: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
642: AND del.org_id = p_org_id
643: UNION ALL
644: SELECT amount_due_remaining
645: FROM iex_promise_details pro, okc_k_headers_b okch
646: WHERE okch.bill_to_site_use_id = p_site_use_id
647: AND pro.status in ('COLLECTABLE', 'PENDING')
648: AND pro.state = 'BROKEN_PROMISE'
649: AND pro.amount_due_remaining > 0

Line 680: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del

676: IS
677: CURSOR c_party_amt IS
678: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
679: -- SELECT SUM(promise_amount)
680: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
681: -- WHERE pro.cust_account_id = ca.cust_account_id
682: -- AND ca.party_id = p_party_id
683: -- AND pro.status in ('COLLECTABLE', 'PENDING')
684: -- AND pro.state = 'BROKEN_PROMISE'

Line 693: FROM iex_promise_details pro, iex_delinquencies_all del

689: -- AND pro.delinquency_id = del.delinquency_id
690: -- AND del.status IN ('DELINQUENT', 'PREDELINQUENT');
691: SELECT SUM(promise_amount)
692: FROM ( SELECT promise_amount
693: FROM iex_promise_details pro, iex_delinquencies_all del
694: WHERE del.party_cust_id = p_party_id
695: AND pro.status in ('COLLECTABLE', 'PENDING')
696: AND pro.state = 'BROKEN_PROMISE'
697: AND pro.amount_due_remaining > 0

Line 704: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca

700: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
701: AND del.org_id = p_org_id
702: UNION ALL
703: SELECT promise_amount
704: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
705: WHERE ca.party_id = p_party_id
706: AND pro.cust_account_id = ca.cust_account_id
707: AND pro.status in ('COLLECTABLE', 'PENDING')
708: AND pro.state = 'BROKEN_PROMISE'

Line 716: FROM iex_promise_details pro, iex_delinquencies_all del

712: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
713:
714: CURSOR c_acc_amt IS
715: SELECT SUM(promise_amount)
716: FROM iex_promise_details pro, iex_delinquencies_all del
717: WHERE pro.cust_account_id = p_cust_account_id
718: AND pro.amount_due_remaining > 0
719: AND pro.status in ('COLLECTABLE', 'PENDING')
720: AND pro.state = 'BROKEN_PROMISE'

Line 734: -- FROM iex_promise_details pro, iex_delinquencies del

730:
731: CURSOR c_billto_amt IS
732: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
733: -- SELECT SUM(promise_amount)
734: -- FROM iex_promise_details pro, iex_delinquencies del
735: -- WHERE del.customer_site_use_id = p_site_use_id
736: -- AND pro.amount_due_remaining > 0
737: -- AND pro.status in ('COLLECTABLE', 'PENDING')
738: -- AND pro.state = 'BROKEN_PROMISE'

Line 744: FROM iex_promise_details pro, iex_delinquencies_all del

740: -- AND pro.delinquency_id = del.delinquency_id
741: -- AND del.status <> 'CURRENT';
742: SELECT SUM(promise_amount)
743: FROM ( SELECT promise_amount
744: FROM iex_promise_details pro, iex_delinquencies_all del
745: WHERE del.customer_site_use_id = p_site_use_id
746: AND pro.status in ('COLLECTABLE', 'PENDING')
747: AND pro.state = 'BROKEN_PROMISE'
748: AND pro.amount_due_remaining > 0

Line 755: FROM iex_promise_details pro, okc_k_headers_b okch

751: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
752: AND del.org_id = p_org_id
753: UNION ALL
754: SELECT promise_amount
755: FROM iex_promise_details pro, okc_k_headers_b okch
756: WHERE okch.bill_to_site_use_id = p_site_use_id
757: AND pro.status in ('COLLECTABLE', 'PENDING')
758: AND pro.state = 'BROKEN_PROMISE'
759: AND pro.amount_due_remaining > 0