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 168: ' FROM iex_promise_details pro, iex_delinquencies_all del ' ||

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

Line 185: ' FROM iex_promise_details pro' ||

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

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

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

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

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

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

596: IS
597: CURSOR c_party_amt IS
598: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
599: -- SELECT SUM(amount_due_remaining)
600: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
601: -- WHERE pro.cust_account_id = ca.cust_account_id
602: -- AND ca.party_id = p_party_id
603: -- AND pro.status in ('COLLECTABLE', 'PENDING')
604: -- AND pro.state = 'BROKEN_PROMISE'

Line 611: FROM iex_promise_details pro, iex_delinquencies_all del

607: -- AND pro.delinquency_id = del.delinquency_id(+)
608: -- AND del.status(+) <> 'CURRENT';
609: SELECT SUM(amount_due_remaining)
610: FROM ( SELECT amount_due_remaining
611: FROM iex_promise_details pro, iex_delinquencies_all del
612: WHERE del.party_cust_id = p_party_id
613: AND pro.status in ('COLLECTABLE', 'PENDING')
614: AND pro.state = 'BROKEN_PROMISE'
615: AND pro.amount_due_remaining > 0

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

618: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
619: AND del.org_id = p_org_id
620: UNION ALL
621: SELECT amount_due_remaining
622: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
623: WHERE ca.cust_account_id = pro.cust_account_id
624: AND ca.party_id = p_party_id
625: AND pro.status in ('COLLECTABLE', 'PENDING')
626: AND pro.state = 'BROKEN_PROMISE'

Line 634: FROM iex_promise_details pro, iex_delinquencies_all del

630: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
631:
632: CURSOR c_acc_amt IS
633: SELECT SUM(amount_due_remaining)
634: FROM iex_promise_details pro, iex_delinquencies_all del
635: WHERE pro.cust_account_id = p_cust_account_id
636: AND pro.status in ('COLLECTABLE', 'PENDING')
637: AND pro.state = 'BROKEN_PROMISE'
638: AND pro.amount_due_remaining > 0

Line 652: -- FROM iex_promise_details pro, iex_delinquencies del

648:
649: CURSOR c_billto_amt IS
650: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
651: -- SELECT SUM(amount_due_remaining)
652: -- FROM iex_promise_details pro, iex_delinquencies del
653: -- WHERE del.customer_site_use_id = p_site_use_id
654: -- AND pro.status in ('COLLECTABLE', 'PENDING')
655: -- AND pro.state = 'BROKEN_PROMISE'
656: -- AND pro.amount_due_remaining > 0

Line 663: FROM iex_promise_details pro, iex_delinquencies_all del

659: -- AND del.status <> 'CURRENT';
660: -- AND del.status IN ('DELINQUENT', 'PREDELINQUENT');
661: SELECT SUM(amount_due_remaining)
662: FROM ( SELECT amount_due_remaining
663: FROM iex_promise_details pro, iex_delinquencies_all del
664: WHERE del.customer_site_use_id = p_site_use_id
665: AND pro.status in ('COLLECTABLE', 'PENDING')
666: AND pro.state = 'BROKEN_PROMISE'
667: AND pro.amount_due_remaining > 0

Line 674: FROM iex_promise_details pro, okc_k_headers_b okch

670: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
671: AND del.org_id = p_org_id
672: UNION ALL
673: SELECT amount_due_remaining
674: FROM iex_promise_details pro, okc_k_headers_b okch
675: WHERE okch.bill_to_site_use_id = p_site_use_id
676: AND pro.status in ('COLLECTABLE', 'PENDING')
677: AND pro.state = 'BROKEN_PROMISE'
678: AND pro.amount_due_remaining > 0

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

705: IS
706: CURSOR c_party_amt IS
707: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
708: -- SELECT SUM(promise_amount)
709: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
710: -- WHERE pro.cust_account_id = ca.cust_account_id
711: -- AND ca.party_id = p_party_id
712: -- AND pro.status in ('COLLECTABLE', 'PENDING')
713: -- AND pro.state = 'BROKEN_PROMISE'

Line 722: FROM iex_promise_details pro, iex_delinquencies_all del

718: -- AND pro.delinquency_id = del.delinquency_id
719: -- AND del.status IN ('DELINQUENT', 'PREDELINQUENT');
720: SELECT SUM(promise_amount)
721: FROM ( SELECT promise_amount
722: FROM iex_promise_details pro, iex_delinquencies_all del
723: WHERE del.party_cust_id = p_party_id
724: AND pro.status in ('COLLECTABLE', 'PENDING')
725: AND pro.state = 'BROKEN_PROMISE'
726: AND pro.amount_due_remaining > 0

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

729: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
730: AND del.org_id = p_org_id
731: UNION ALL
732: SELECT promise_amount
733: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
734: WHERE ca.party_id = p_party_id
735: AND pro.cust_account_id = ca.cust_account_id
736: AND pro.status in ('COLLECTABLE', 'PENDING')
737: AND pro.state = 'BROKEN_PROMISE'

Line 745: FROM iex_promise_details pro, iex_delinquencies_all del

741: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
742:
743: CURSOR c_acc_amt IS
744: SELECT SUM(promise_amount)
745: FROM iex_promise_details pro, iex_delinquencies_all del
746: WHERE pro.cust_account_id = p_cust_account_id
747: AND pro.amount_due_remaining > 0
748: AND pro.status in ('COLLECTABLE', 'PENDING')
749: AND pro.state = 'BROKEN_PROMISE'

Line 763: -- FROM iex_promise_details pro, iex_delinquencies del

759:
760: CURSOR c_billto_amt IS
761: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
762: -- SELECT SUM(promise_amount)
763: -- FROM iex_promise_details pro, iex_delinquencies del
764: -- WHERE del.customer_site_use_id = p_site_use_id
765: -- AND pro.amount_due_remaining > 0
766: -- AND pro.status in ('COLLECTABLE', 'PENDING')
767: -- AND pro.state = 'BROKEN_PROMISE'

Line 773: FROM iex_promise_details pro, iex_delinquencies_all del

769: -- AND pro.delinquency_id = del.delinquency_id
770: -- AND del.status <> 'CURRENT';
771: SELECT SUM(promise_amount)
772: FROM ( SELECT promise_amount
773: FROM iex_promise_details pro, iex_delinquencies_all del
774: WHERE del.customer_site_use_id = p_site_use_id
775: AND pro.status in ('COLLECTABLE', 'PENDING')
776: AND pro.state = 'BROKEN_PROMISE'
777: AND pro.amount_due_remaining > 0

Line 784: FROM iex_promise_details pro, okc_k_headers_b okch

780: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
781: AND del.org_id = p_org_id
782: UNION ALL
783: SELECT promise_amount
784: FROM iex_promise_details pro, okc_k_headers_b okch
785: WHERE okch.bill_to_site_use_id = p_site_use_id
786: AND pro.status in ('COLLECTABLE', 'PENDING')
787: AND pro.state = 'BROKEN_PROMISE'
788: AND pro.amount_due_remaining > 0