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_ATTR_GRP_PVT dependencies on QP_LIST_HEADERS_B

Line 435: qp_list_headers_b qph

431: qpq.qualifier_datatype attribute_datatype,
432: qpq.qualifier_attr_value attribute_value,
433: 'QUAL' attribute_type
434: from qp_qualifiers qpq,
435: qp_list_headers_b qph
436: where qpq.list_line_id = -1
437: and qph.list_header_id = qpq.list_header_id
438: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)
439: and ((p_qualifier_group is not null and qpq.qualifier_grouping_no in (-1, p_qualifier_group))

Line 531: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph

527: qpl.modifier_level_code modifier_level_code,
528: qpq.qualifier_datatype attribute_datatype,
529: qpq.qualifier_attr_value attribute_value,
530: 'QUAL' attribute_type
531: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph
532: where qpq.list_line_id <> -1
533: and qph.list_header_id = qpq.list_header_id
534: and qpl.list_header_id = qph.list_header_id
535: and qpl.list_line_id = qpq.list_line_id

Line 563: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph

559: qpl.modifier_level_code modifier_level_code,
560: qpa.product_attribute_datatype attribute_datatype,
561: qpa.product_attr_value attribute_value,
562: 'PROD' attribute_type
563: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
564: where qph.list_header_id = qpl.list_header_id
565: and qpl.list_line_id = qpa.list_line_id
566: and qpa.excluder_flag = 'N'
567: and qpl.pricing_phase_id > 1

Line 594: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph

590: qpl.modifier_level_code modifier_level_code,
591: qpa.pricing_attribute_datatype attribute_datatype,
592: qpa.pricing_attr_value_from attribute_value,
593: 'PRIC' attribute_type
594: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
595: where qph.list_header_id = qpl.list_header_id
596: and qpl.list_line_id = qpa.list_line_id
597: and qpl.pricing_phase_id > 1
598: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;

2056: l_status_code VARCHAR2(30) := NULL;
2057: l_status_text VARCHAR2(2000) := NULL;
2058: l_pattern_id NUMBER;
2059: l_qual_exists VARCHAR2(1) := 'N';
2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;

Line 2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;

2057: l_status_text VARCHAR2(2000) := NULL;
2058: l_pattern_id NUMBER;
2059: l_qual_exists VARCHAR2(1) := 'N';
2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;

Line 2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;

2058: l_pattern_id NUMBER;
2059: l_qual_exists VARCHAR2(1) := 'N';
2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2066:

Line 2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;

2059: l_qual_exists VARCHAR2(1) := 'N';
2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2066:
2067: BEGIN

Line 2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;

2060: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2066:
2067: BEGIN
2068: g_call_from_setup := 'Y';

Line 2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;

2061: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2062: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2063: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2064: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2065: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2066:
2067: BEGIN
2068: g_call_from_setup := 'Y';
2069:

Line 2173: from qp_list_headers_b

2169: l_CURRENCY_CODE,
2170: l_ASK_FOR_FLAG,
2171: l_HEADER_LIMIT_EXISTS,
2172: l_SOURCE_SYSTEM_CODE
2173: from qp_list_headers_b
2174: where list_header_id = p_list_header_id;
2175:
2176: -- update header pattern records
2177: update qp_attribute_groups