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 242: FROM QP_LIST_HEADERS_B

238: BEGIN
239: IF p_list_header_id IS NOT NULL THEN
240: SELECT ACTIVE_FLAG
241: INTO l_active_flag
242: FROM QP_LIST_HEADERS_B
243: WHERE list_header_id=p_list_header_id;
244: END IF;
245: IF p_list_line_id IS NOT NULL THEN
246: SELECT ListHeaders.ACTIVE_FLAG

Line 248: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines

244: END IF;
245: IF p_list_line_id IS NOT NULL THEN
246: SELECT ListHeaders.ACTIVE_FLAG
247: INTO l_active_flag
248: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines
249: WHERE ListHeaders.LIST_HEADER_ID = ListLines.LIST_HEADER_ID AND
250: ListLines.LIST_LINE_ID = p_list_line_id AND
251: rownum = 1;
252: END IF;

Line 1125: FROM QP_LIST_HEADERS qplh ,

1121: MULTIPLE_PRICE_LIST_EXCEPTION EXCEPTION;
1122:
1123: Cursor C_modifier(p_list_header_id number) IS
1124: SELECT count(1)
1125: FROM QP_LIST_HEADERS qplh ,
1126: QP_QUALIFIERS qpq
1127: WHERE qplh.list_header_id = p_list_header_id
1128: AND qplh.list_header_id = qpq.list_header_id
1129: AND qpq.qualifier_context = 'MODLIST'

Line 1304: from qp_list_headers_vl

1300:
1301: BEGIN
1302: select list_type_code
1303: into l_list_type_code
1304: from qp_list_headers_vl
1305: where list_header_id = p_list_header_id;
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: NULL;

Line 1580: from qp_list_headers_vl

1576:
1577: BEGIN
1578: select list_type_code, list_header_id
1579: into l_list_type_code, l_list_header_id
1580: from qp_list_headers_vl
1581: where list_header_id = (select list_header_id
1582: from qp_list_lines
1583: where list_line_id = p_list_line_id);
1584: EXCEPTION

Line 1912: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE

1908: ) IS
1909:
1910: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1911: := FND_API.G_MISS_NUM;
1912: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1913: := FND_API.G_MISS_NUM;
1914:
1915: /*
1916: Cursor C_pricing_attr(p_list_line_id number) IS

Line 2541: qp_list_headers_b qph

2537: and product_attr_value = p_product_attr_value
2538: and not exists (
2539: select 'Y'
2540: from qp_list_lines qpl,
2541: qp_list_headers_b qph
2542: where qpl.list_line_id = p_list_line_id
2543: and qpl.modifier_level_code = 'LINEGROUP'
2544: and qph.list_header_id = p_list_header_id
2545: and qph.active_flag = 'Y'

Line 2551: qp_list_headers_b qph

2547: union
2548: select 'Y'
2549: from qp_rltd_modifiers qpr,
2550: qp_list_lines qpl,
2551: qp_list_headers_b qph
2552: where qpl.list_line_id = p_list_line_id
2553: and qpr.to_rltd_modifier_id = p_list_line_id
2554: and qpr.rltd_modifier_grp_type = 'BENEFIT'
2555: and qpl.list_line_type_code = 'DIS'

Line 2564: qp_list_headers_b qph

2560: and rownum = 1
2561: union
2562: select 'Y'
2563: from qp_list_lines qpl,
2564: qp_list_headers_b qph
2565: where qpl.list_line_id = p_list_line_id
2566: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')
2567: and qph.list_header_id = p_list_header_id
2568: and qph.active_flag = 'Y'

Line 2639: qp_list_headers_b qph

2635: and not exists (
2636: select 'Y'
2637: from qp_pricing_attributes qpa,
2638: qp_list_lines qpl,
2639: qp_list_headers_b qph
2640: where qpa.pricing_phase_id = p_old_pricing_phase_id
2641: and qpa.product_attribute = l_product_attribute
2642: and qpa.product_attr_value = l_product_attr_value
2643: and qpl.list_line_id = qpa.list_line_id

Line 2653: qp_list_headers_b qph

2649: select 'Y'
2650: from qp_rltd_modifiers qpr,
2651: qp_list_lines qpl,
2652: qp_pricing_attributes qpa,
2653: qp_list_headers_b qph
2654: where qpa.pricing_phase_id = p_old_pricing_phase_id
2655: and qpa.product_attribute = l_product_attribute
2656: and qpa.product_attr_value = l_product_attr_value
2657: and qpl.list_line_id = qpa.list_line_id

Line 2668: qp_list_headers_b qph

2664: union
2665: select 'Y'
2666: from qp_list_lines qpl,
2667: qp_pricing_attributes qpa,
2668: qp_list_headers_b qph
2669: where qpa.pricing_phase_id = p_old_pricing_phase_id
2670: and qpa.product_attribute = l_product_attribute
2671: and qpa.product_attr_value = l_product_attr_value
2672: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')

Line 2753: qp_list_headers_b qph

2749: and not exists (
2750: select 'Y'
2751: from qp_pricing_attributes qpa,
2752: qp_list_lines qpl,
2753: qp_list_headers_b qph
2754: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2755: and qpa.product_attribute = line_cursor.product_attribute
2756: and qpa.product_attr_value = line_cursor.product_attr_value
2757: and qpl.list_line_id = qpa.list_line_id

Line 2767: qp_list_headers_b qph

2763: select 'Y'
2764: from qp_rltd_modifiers qpr,
2765: qp_list_lines qpl,
2766: qp_pricing_attributes qpa,
2767: qp_list_headers_b qph
2768: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2769: and qpa.product_attribute = line_cursor.product_attribute
2770: and qpa.product_attr_value = line_cursor.product_attr_value
2771: and qpl.list_line_id = qpa.list_line_id

Line 2782: qp_list_headers_b qph

2778: union
2779: select 'Y'
2780: from qp_list_lines qpl,
2781: qp_pricing_attributes qpa,
2782: qp_list_headers_b qph
2783: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2784: and qpa.product_attribute = line_cursor.product_attribute
2785: and qpa.product_attr_value = line_cursor.product_attr_value
2786: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')