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 1027: FROM qp_currency_details a

1023: CURSOR c_validate_plist_curr_multi
1024: IS
1025:
1026: SELECT 'X'
1027: FROM qp_currency_details a
1028: ,qp_list_headers_b b
1029: WHERE a.currency_header_id = b.currency_header_id
1030: AND a.to_currency_code = l_currency_code
1031: AND b.list_header_id = l_price_list_id

Line 1158: ,qp_currency_details b

1154: SELECT DISTINCT a.currency_code currency_code
1155: ,a.name currency_name
1156: ,a.PRECISION currency_precision
1157: FROM fnd_currencies_vl a
1158: ,qp_currency_details b
1159: ,qp_list_headers_b c
1160: WHERE c.list_header_id = l_price_list_id
1161: AND b.currency_header_id = c.currency_header_id
1162: AND a.currency_code = b.to_currency_code

Line 1288: ,qp_currency_details qdt

1284: ,qlhv.description description
1285: ,qlhv.start_date_active start_date_active
1286: ,qlhv.end_date_active end_date_active
1287: FROM qp_list_headers_vl qlhv
1288: ,qp_currency_details qdt
1289: WHERE qlhv.currency_header_id = qdt.currency_header_id
1290: AND qdt.to_currency_code = l_currency_code
1291: AND qlhv.active_flag = 'Y'
1292: --added for MOAC

Line 1340: ,qp_currency_details qdt

1336: ,qlhv.start_date_active start_date_active
1337: ,qlhv.end_date_active end_date_active
1338: FROM qp_list_headers_vl qlhv
1339: ,oe_agreements oa
1340: ,qp_currency_details qdt
1341: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1342: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1343: OR
1344: qlhv.list_type_code = 'PRL'

Line 1399: ,qp_currency_details qdt

1395: ,qlhv.start_date_active start_date_active
1396: ,qlhv.end_date_active end_date_active
1397: FROM qp_list_headers_vl qlhv
1398: ,oe_agreements oa
1399: ,qp_currency_details qdt
1400: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1401: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1402: OR
1403: qlhv.list_type_code = 'PRL'

Line 2318: FROM qp_list_headers_b qb, qp_currency_details qcdt

2314:
2315: END IF;
2316: SELECT qcdt.selling_rounding_factor
2317: INTO l_rounding_factor
2318: FROM qp_list_headers_b qb, qp_currency_details qcdt
2319: WHERE qb.list_header_id = p_price_list_id
2320: AND qcdt.currency_header_id = qb.currency_header_id
2321: AND qcdt.to_currency_code = p_currency_code
2322: AND l_pricing_effective_date BETWEEN

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

2810: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2811: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2812:
2813: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2814: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh
2815: WHERE qcd.currency_header_id = qlh.currency_header_id AND fnd.currency_code = qcd.to_currency_code
2816: AND qlh.list_type_code in (''PRL'', ''AGR'') and fnd.currency_flag = ''Y''
2817: AND fnd.enabled_flag = ''Y''';
2818: BEGIN