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_LIST_HEADERS_B

Line 495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

491: FROM qp_event_phases
492: WHERE pricing_phase_id > 1
493: AND ROWNUM < 7)
494: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
496: WHERE lhb.pricing_phase_id = b.pricing_phase_id
497: AND qph.list_header_id = lhb.list_header_id
498: AND qph.active_flag = 'Y'
499: AND qprs.request_type_code = p_request_type_code

Line 698: ,qp_list_headers_b b

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
702: AND TRUNC(l_temp_date) >= TRUNC(NVL(a.start_date_active, l_temp_date))

Line 712: FROM qp_list_headers_b

708: CURSOR c_validate_pl_curr_no_multi
709: IS
710:
711: SELECT 'X'
712: FROM qp_list_headers_b
713: WHERE currency_code = l_currency_code
714: AND list_header_id = l_price_list_id
715: AND TRUNC(l_temp_date) >= TRUNC(NVL(start_date_active, l_temp_date))
716: AND TRUNC(l_temp_date) <= TRUNC(NVL(end_date_active, l_temp_date));

Line 829: ,qp_list_headers_b c

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
833: AND c.list_type_code IN ('PRL', 'AGR')

Line 1536: -- qp_list_headers_b l,

1532: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1533: t.name payment_term_name, a.start_date_active, a.end_date_active
1534: FROM oe_agreements_lov_v a, qp_list_headers_vl q,
1535: hz_parties p, hz_cust_accounts c, ra_terms_tl t,
1536: -- qp_list_headers_b l,
1537: oe_transaction_types_all ot
1538: WHERE a.sold_to_org_id IN (
1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1540: UNION

Line 1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l

1592: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1593: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1594: null payment_term_name, a.start_date_active, a.end_date_active
1595: from oe_agreements_lov_v a, qp_list_headers_vl q,
1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1597: where a.sold_to_org_id in (
1598: select to_number(p_sold_to_org_id) from dual
1599: union
1600: select -1 from dual

Line 1628: --, qp_list_headers_b l

1624: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1625: a.agreement_type, q.name price_list_name, NULL customer_name,
1626: NULL payment_term_name, a.start_date_active, a.end_date_active
1627: FROM oe_agreements_lov_v a, qp_list_headers_vl q
1628: --, qp_list_headers_b l
1629: WHERE l_temp_date BETWEEN
1630: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1631: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND
1632: a.price_list_id = q.list_header_id

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 2023: FROM qp_list_headers_b qb

2019:
2020: END IF;
2021: SELECT qb.rounding_factor
2022: INTO l_rounding_factor
2023: FROM qp_list_headers_b qb
2024: WHERE qb.list_header_id = p_price_list_id;
2025: /* for bug 2350218
2026: and qb.currency_code = p_currency_code
2027: and l_pricing_effective_date BETWEEN

Line 2479: FROM fnd_currencies_vl fnd, qp_list_headers_b qlh

2475: ,x_sql_string OUT NOCOPY VARCHAR2
2476: )
2477: IS
2478: l_no_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2479: FROM fnd_currencies_vl fnd, 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

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

Line 2636: SELECT list_header_id FROM qp_list_headers_b

2632: l_MODIFIER_LIST_rec Qp_Modifiers_Pub.Modifier_List_Rec_Type;
2633: l_MODIFIER_LIST_tbl Qp_Modifiers_Pub.Modifier_List_Tbl_Type;
2634:
2635: CURSOR blanket_price_lists( p_blkt_header_id NUMBER) IS
2636: SELECT list_header_id FROM qp_list_headers_b
2637: WHERE list_source_code = 'BSO'
2638: AND orig_system_header_ref = p_blkt_header_id
2639: AND list_type_code = 'PRL';
2640:

Line 2642: SELECT list_header_id FROM qp_list_headers_b

2638: AND orig_system_header_ref = p_blkt_header_id
2639: AND list_type_code = 'PRL';
2640:
2641: CURSOR blanket_modifier_lists( p_blkt_header_id NUMBER) IS
2642: SELECT list_header_id FROM qp_list_headers_b
2643: WHERE list_source_code = 'BSO'
2644: AND orig_system_header_ref = p_blkt_header_id
2645: AND list_type_code NOT IN ('PRL','AGR');
2646:

Line 2747: QP_LIST_HEADERS_B QLH

2743: SELECT 'X'
2744: FROM
2745: QP_PRICING_ATTRIBUTES A,
2746: QP_LIST_LINES L,
2747: QP_LIST_HEADERS_B QLH
2748: WHERE
2749: A.LIST_HEADER_ID = P_Price_List_Id AND
2750: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
2751: A.PRODUCT_ATTRIBUTE IN ( 'PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3' ) AND

Line 2808: QP_LIST_HEADERS_B QLH

2804: SELECT 'X'
2805: FROM
2806: QP_PRICING_ATTRIBUTES A,
2807: QP_LIST_LINES L,
2808: QP_LIST_HEADERS_B QLH
2809: WHERE
2810: A.LIST_HEADER_ID = P_Price_List_Id AND
2811: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
2812: A.PRODUCT_ATTRIBUTE IN ( 'PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE3' ) AND

Line 2865: QP_LIST_HEADERS_B QLH,

2861: SELECT FL.price_modifier_list_id
2862: FROM
2863: QP_PRICING_ATTRIBUTES A,
2864: QP_LIST_LINES L,
2865: QP_LIST_HEADERS_B QLH,
2866: QP_PRICE_FORMULA_LINES FL
2867: WHERE
2868: A.LIST_HEADER_ID = P_Price_List_Id AND
2869: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND

Line 2889: QP_LIST_HEADERS_B QLH,

2885: SELECT DISTINCT FL.pricing_attribute_context, FL.pricing_attribute
2886: FROM
2887: QP_PRICING_ATTRIBUTES A,
2888: QP_LIST_LINES L,
2889: QP_LIST_HEADERS_B QLH,
2890: QP_PRICE_FORMULA_LINES FL
2891: WHERE
2892: A.LIST_HEADER_ID = P_Price_List_Id AND
2893: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND