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.QP_UTIL_PUB dependencies on QP_CURRENCY_DETAILS

Line 697: FROM qp_currency_details a

693: CURSOR c_validate_plist_curr_multi
694: IS
695:
696: SELECT 'X'
697: FROM qp_currency_details a
698: ,qp_list_headers_b b
699: WHERE a.currency_header_id = b.currency_header_id
700: AND a.to_currency_code = l_currency_code
701: AND b.list_header_id = l_price_list_id

Line 828: ,qp_currency_details b

824: SELECT DISTINCT a.currency_code currency_code
825: ,a.name currency_name
826: ,a.PRECISION currency_precision
827: FROM fnd_currencies_vl a
828: ,qp_currency_details b
829: ,qp_list_headers_b c
830: WHERE c.list_header_id = l_price_list_id
831: AND b.currency_header_id = c.currency_header_id
832: AND a.currency_code = b.to_currency_code

Line 958: ,qp_currency_details qdt

954: ,qlhv.description description
955: ,qlhv.start_date_active start_date_active
956: ,qlhv.end_date_active end_date_active
957: FROM qp_list_headers_vl qlhv
958: ,qp_currency_details qdt
959: WHERE qlhv.currency_header_id = qdt.currency_header_id
960: AND qdt.to_currency_code = l_currency_code
961: AND qlhv.active_flag = 'Y'
962: --added for MOAC

Line 1010: ,qp_currency_details qdt

1006: ,qlhv.start_date_active start_date_active
1007: ,qlhv.end_date_active end_date_active
1008: FROM qp_list_headers_vl qlhv
1009: ,oe_agreements oa
1010: ,qp_currency_details qdt
1011: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1012: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1013: OR
1014: qlhv.list_type_code = 'PRL'

Line 1069: ,qp_currency_details qdt

1065: ,qlhv.start_date_active start_date_active
1066: ,qlhv.end_date_active end_date_active
1067: FROM qp_list_headers_vl qlhv
1068: ,oe_agreements oa
1069: ,qp_currency_details qdt
1070: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1071: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1072: OR
1073: qlhv.list_type_code = 'PRL'

Line 1988: FROM qp_list_headers_b qb, qp_currency_details qcdt

1984:
1985: END IF;
1986: SELECT qcdt.selling_rounding_factor
1987: INTO l_rounding_factor
1988: FROM qp_list_headers_b qb, qp_currency_details qcdt
1989: WHERE qb.list_header_id = p_price_list_id
1990: AND qcdt.currency_header_id = qb.currency_header_id
1991: AND qcdt.to_currency_code = p_currency_code
1992: AND l_pricing_effective_date BETWEEN

Line 2484: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh

2480: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2481: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2482:
2483: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2484: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh
2485: WHERE qcd.currency_header_id = qlh.currency_header_id AND fnd.currency_code = qcd.to_currency_code
2486: AND qlh.list_type_code in (''PRL'', ''AGR'') and fnd.currency_flag = ''Y''
2487: AND fnd.enabled_flag = ''Y''';
2488: BEGIN