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.OKC_OC_INT_KTQ_PVT dependencies on OKC_CONVERSION_ATTRIBS_V

Line 724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;

720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;
727:
728:

Line 725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;

721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;
727:
728:
729: PROCEDURE create_quote_from_k( p_api_version IN NUMBER

Line 726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;

722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;
727:
728:
729: PROCEDURE create_quote_from_k( p_api_version IN NUMBER
730: ,p_init_msg_list IN VARCHAR2

Line 829: FROM okc_conversion_attribs_v

825: CURSOR c_conv_type (b_id1 VARCHAR2, b_id2 VARCHAR2) IS
826: SELECT conversion_type,
827: conversion_rate,
828: conversion_date
829: FROM okc_conversion_attribs_v
830: WHERE conversion_type = b_id1
831: AND dnz_chr_id = p_chr_id;
832:
833: e_exit EXCEPTION;