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 OKC_K_HEADERS_B

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 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 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 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 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