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 441: qp_list_headers_b qph

437: qpq.qualifier_datatype attribute_datatype,
438: qpq.qualifier_attr_value attribute_value,
439: 'QUAL' attribute_type
440: from qp_qualifiers qpq,
441: qp_list_headers_b qph
442: where qpq.list_line_id = -1
443: and qph.list_header_id = qpq.list_header_id
444: and qpq.list_header_id = nvl(p_list_header_id, qpq.list_header_id)
445: and ((p_qualifier_group is not null and qpq.qualifier_grouping_no in (-1, p_qualifier_group))

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

533: qpl.modifier_level_code modifier_level_code,
534: qpq.qualifier_datatype attribute_datatype,
535: qpq.qualifier_attr_value attribute_value,
536: 'QUAL' attribute_type
537: from qp_list_lines qpl, qp_qualifiers qpq, qp_list_headers_b qph
538: where qpq.list_line_id <> -1
539: and qph.list_header_id = qpq.list_header_id
540: and qpl.list_header_id = qph.list_header_id
541: and qpl.list_line_id = qpq.list_line_id

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

565: qpl.modifier_level_code modifier_level_code,
566: qpa.product_attribute_datatype attribute_datatype,
567: qpa.product_attr_value attribute_value,
568: 'PROD' attribute_type
569: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
570: where qph.list_header_id = qpl.list_header_id
571: and qpl.list_line_id = qpa.list_line_id
572: and qpa.excluder_flag = 'N'
573: and qpl.pricing_phase_id > 1

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

596: qpl.modifier_level_code modifier_level_code,
597: qpa.pricing_attribute_datatype attribute_datatype,
598: qpa.pricing_attr_value_from attribute_value,
599: 'PRIC' attribute_type
600: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
601: where qph.list_header_id = qpl.list_header_id
602: and qpl.list_line_id = qpa.list_line_id
603: and qpl.pricing_phase_id > 1
604: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;

2062: l_status_code VARCHAR2(30) := NULL;
2063: l_status_text VARCHAR2(2000) := NULL;
2064: l_pattern_id NUMBER;
2065: l_qual_exists VARCHAR2(1) := 'N';
2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;

Line 2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;

2063: l_status_text VARCHAR2(2000) := NULL;
2064: l_pattern_id NUMBER;
2065: l_qual_exists VARCHAR2(1) := 'N';
2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;

Line 2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;

2064: l_pattern_id NUMBER;
2065: l_qual_exists VARCHAR2(1) := 'N';
2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2072:

Line 2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;

2065: l_qual_exists VARCHAR2(1) := 'N';
2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2072:
2073: BEGIN

Line 2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;

2066: l_ACTIVE_FLAG qp_list_headers_b.active_flag%type;
2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2072:
2073: BEGIN
2074: g_call_from_setup := 'Y';

Line 2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;

2067: l_LIST_TYPE_CODE qp_list_headers_b.list_type_code%type;
2068: l_CURRENCY_CODE qp_list_headers_b.CURRENCY_CODE%type;
2069: l_ASK_FOR_FLAG qp_list_headers_b.ASK_FOR_FLAG%type;
2070: l_HEADER_LIMIT_EXISTS qp_list_headers_b.LIMIT_EXISTS_FLAG%type;
2071: l_SOURCE_SYSTEM_CODE qp_list_headers_b.SOURCE_SYSTEM_CODE%type;
2072:
2073: BEGIN
2074: g_call_from_setup := 'Y';
2075:

Line 2179: from qp_list_headers_b

2175: l_CURRENCY_CODE,
2176: l_ASK_FOR_FLAG,
2177: l_HEADER_LIMIT_EXISTS,
2178: l_SOURCE_SYSTEM_CODE
2179: from qp_list_headers_b
2180: where list_header_id = p_list_header_id;
2181:
2182: -- update header pattern records
2183: update qp_attribute_groups