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