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_DELAYED_REQUESTS_UTIL dependencies on QP_LIST_HEADERS

Line 250: FROM QP_LIST_HEADERS_B

246: BEGIN
247: IF p_list_header_id IS NOT NULL THEN
248: SELECT ACTIVE_FLAG
249: INTO l_active_flag
250: FROM QP_LIST_HEADERS_B
251: WHERE list_header_id=p_list_header_id;
252: END IF;
253: IF p_list_line_id IS NOT NULL THEN
254: SELECT ListHeaders.ACTIVE_FLAG

Line 256: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines

252: END IF;
253: IF p_list_line_id IS NOT NULL THEN
254: SELECT ListHeaders.ACTIVE_FLAG
255: INTO l_active_flag
256: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines
257: WHERE ListHeaders.LIST_HEADER_ID = ListLines.LIST_HEADER_ID AND
258: ListLines.LIST_LINE_ID = p_list_line_id AND
259: rownum = 1;
260: END IF;

Line 1133: FROM QP_LIST_HEADERS qplh ,

1129: MULTIPLE_PRICE_LIST_EXCEPTION EXCEPTION;
1130:
1131: Cursor C_modifier(p_list_header_id number) IS
1132: SELECT count(1)
1133: FROM QP_LIST_HEADERS qplh ,
1134: QP_QUALIFIERS qpq
1135: WHERE qplh.list_header_id = p_list_header_id
1136: AND qplh.list_header_id = qpq.list_header_id
1137: AND qpq.qualifier_context = 'MODLIST'

Line 1312: from qp_list_headers_vl

1308:
1309: BEGIN
1310: select list_type_code
1311: into l_list_type_code
1312: from qp_list_headers_vl
1313: where list_header_id = p_list_header_id;
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: NULL;

Line 1588: from qp_list_headers_vl

1584:
1585: BEGIN
1586: select list_type_code, list_header_id
1587: into l_list_type_code, l_list_header_id
1588: from qp_list_headers_vl
1589: where list_header_id = (select list_header_id
1590: from qp_list_lines
1591: where list_line_id = p_list_line_id);
1592: EXCEPTION

Line 1920: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE

1916: ) IS
1917:
1918: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1919: := FND_API.G_MISS_NUM;
1920: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1921: := FND_API.G_MISS_NUM;
1922:
1923: /*
1924: Cursor C_pricing_attr(p_list_line_id number) IS

Line 2552: qp_list_headers_b qph

2548: and product_attr_value = p_product_attr_value
2549: and not exists (
2550: select 'Y'
2551: from qp_list_lines qpl,
2552: qp_list_headers_b qph
2553: where qpl.list_line_id = p_list_line_id
2554: and qpl.modifier_level_code = 'LINEGROUP'
2555: and qph.list_header_id = p_list_header_id
2556: and qph.active_flag = 'Y'

Line 2562: qp_list_headers_b qph

2558: union
2559: select 'Y'
2560: from qp_rltd_modifiers qpr,
2561: qp_list_lines qpl,
2562: qp_list_headers_b qph
2563: where qpl.list_line_id = p_list_line_id
2564: and qpr.to_rltd_modifier_id = p_list_line_id
2565: and qpr.rltd_modifier_grp_type = 'BENEFIT'
2566: and qpl.list_line_type_code = 'DIS'

Line 2575: qp_list_headers_b qph

2571: and rownum = 1
2572: union
2573: select 'Y'
2574: from qp_list_lines qpl,
2575: qp_list_headers_b qph
2576: where qpl.list_line_id = p_list_line_id
2577: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')
2578: and qph.list_header_id = p_list_header_id
2579: and qph.active_flag = 'Y'

Line 2650: qp_list_headers_b qph

2646: and not exists (
2647: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2648: from qp_pricing_attributes qpa,
2649: qp_list_lines qpl,
2650: qp_list_headers_b qph
2651: where qpa.pricing_phase_id = p_old_pricing_phase_id
2652: and qpa.product_attribute = l_product_attribute
2653: and qpa.product_attr_value = l_product_attr_value
2654: and qpl.list_line_id = qpa.list_line_id

Line 2664: qp_list_headers_b qph

2660: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2661: from qp_rltd_modifiers qpr,
2662: qp_list_lines qpl,
2663: qp_pricing_attributes qpa,
2664: qp_list_headers_b qph
2665: where qpa.pricing_phase_id = p_old_pricing_phase_id
2666: and qpa.product_attribute = l_product_attribute
2667: and qpa.product_attr_value = l_product_attr_value
2668: and qpl.list_line_id = qpa.list_line_id

Line 2679: qp_list_headers_b qph

2675: union
2676: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2677: from qp_list_lines qpl,
2678: qp_pricing_attributes qpa,
2679: qp_list_headers_b qph
2680: where qpa.pricing_phase_id = p_old_pricing_phase_id
2681: and qpa.product_attribute = l_product_attribute
2682: and qpa.product_attr_value = l_product_attr_value
2683: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')

Line 2764: qp_list_headers_b qph

2760: and not exists (
2761: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2762: from qp_pricing_attributes qpa,
2763: qp_list_lines qpl,
2764: qp_list_headers_b qph
2765: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2766: and qpa.product_attribute = line_cursor.product_attribute
2767: and qpa.product_attr_value = line_cursor.product_attr_value
2768: and qpl.list_line_id = qpa.list_line_id

Line 2778: qp_list_headers_b qph

2774: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2775: from qp_rltd_modifiers qpr,
2776: qp_list_lines qpl,
2777: qp_pricing_attributes qpa,
2778: qp_list_headers_b qph
2779: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2780: and qpa.product_attribute = line_cursor.product_attribute
2781: and qpa.product_attr_value = line_cursor.product_attr_value
2782: and qpl.list_line_id = qpa.list_line_id

Line 2793: qp_list_headers_b qph

2789: union
2790: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2791: from qp_list_lines qpl,
2792: qp_pricing_attributes qpa,
2793: qp_list_headers_b qph
2794: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2795: and qpa.product_attribute = line_cursor.product_attribute
2796: and qpa.product_attr_value = line_cursor.product_attr_value
2797: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')