APPS.QP_PS_ATTR_GRP_PVT dependencies on QP_LIST_HEADER_PHASES

Line 31: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

27: -- Modifier Headers
28: SELECT /*+ ordered USE_NL(qplhp qpag) */
29: qplhp.pricing_phase_id, qpag.pattern_id,
30: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
31: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
32: WHERE qpag.list_header_id = qplhp.list_header_id
33: AND qpag.list_line_id = -1
34: UNION ALL
35: -- Price List Lines

Line 69: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

65: -- Modifier Headers
66: SELECT /*+ ordered USE_NL(qplhp qpag) */
67: qplhp.pricing_phase_id, qpag.pattern_id,
68: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
69: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
70: WHERE qplhp.list_header_id = p_list_header_id
71: AND qpag.list_header_id = qplhp.list_header_id
72: AND qpag.list_line_id = -1
73: )b

Line 119: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

115: -- Modifier Headers
116: SELECT /*+ ordered */
117: qplhp.pricing_phase_id, qpag.pattern_id,
118: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
119: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
120: WHERE qpag.list_line_id = -1
121: AND qpag.list_header_id = qplhp.list_header_id
122: )b
123: GROUP BY pricing_phase_id, pattern_id;

Line 642: from qp_list_header_phases qplhp, qp_attribute_groups qpag

638: UNION ALL
639: -- Modifier Headers
640: select /*+ ordered */ qplhp.pricing_phase_id, qpag.pattern_id, qpag.START_DATE_ACTIVE_H sda,
641: qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
642: from qp_list_header_phases qplhp, qp_attribute_groups qpag
643: where qpag.list_header_id = qplhp.list_header_id
644: and qpag.list_line_id = -1
645: union all
646: -- Price List Lines

Line 826: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)

822: update qp_patterns a set segment_count = (select count(segment_id) from qp_patterns b where a.pattern_id = b.pattern_id);
823: /*Populate row in qp_list_heder_phases when no qualifer is
824: present for lines or headers for that phase and will poulate 'Y' for PRIC_PROD_ATTR_ONLY_FLAG*/
825: IF p_list_header_id IS NULL THEN
826: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
827: (select distinct list_header_id, pricing_phase_id,'Y'
828: from qp_list_lines
829: where pricing_phase_id > 1
830: and qualification_ind in (0,4,20)

Line 833: FROM qp_list_header_phases

829: where pricing_phase_id > 1
830: and qualification_ind in (0,4,20)
831: MINUS
832: SELECT distinct list_header_id, pricing_phase_id,'Y'
833: FROM qp_list_header_phases
834: );
835:
836: -- bug 12731268
837: UPDATE qp_list_lines

Line 843: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)

839: WHERE pattern_id IN (-2,-3)
840: AND list_line_type_code IN ('PLL','PBH');
841:
842: ELSE
843: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
844: (select distinct list_header_id, pricing_phase_id,'Y'
845: from qp_list_lines
846: where pricing_phase_id > 1
847: and qualification_ind in (0,4,20)

Line 851: FROM qp_list_header_phases

847: and qualification_ind in (0,4,20)
848: and list_header_id = nvl(p_list_header_id, list_header_id)
849: MINUS
850: SELECT distinct list_header_id, pricing_phase_id,'Y'
851: FROM qp_list_header_phases
852: where list_header_id = nvl(p_list_header_id, list_header_id)
853: );
854:
855: -- bug 12731268

Line 3493: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)

3489: /*Populate row in qp_list_heder_phases when no qualifer is
3490: present for lines or headers for that phase and will poulate 'Y' for PRIC_PROD_ATTR_ONLY_FLAG*/
3491:
3492: FORALL i in 1 .. g_list_line_id_final_tbl.COUNT
3493: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
3494: (select /*+ index(QP_LIST_LINES QP_LIST_LINES_U1) */ distinct list_header_id, pricing_phase_id,'Y'
3495: from qp_list_lines
3496: where pricing_phase_id > 1
3497: and qualification_ind in (0,4,20)

Line 3501: FROM qp_list_header_phases

3497: and qualification_ind in (0,4,20)
3498: and list_header_id = g_list_header_id_final_tbl(i)
3499: MINUS
3500: SELECT distinct list_header_id, pricing_phase_id,'Y'
3501: FROM qp_list_header_phases
3502: where list_header_id = g_list_header_id_final_tbl(i)
3503: );
3504: END if;
3505: EXCEPTION

Line 3774: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)

3770: /*Populate row in qp_list_heder_phases when no qualifer is
3771: present for lines or headers for that phase and will poulate 'Y' for PRIC_PROD_ATTR_ONLY_FLAG*/
3772:
3773: FORALL i in 1 .. g_list_line_id_final_tbl.COUNT
3774: insert into qp_list_header_phases (list_header_id,pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
3775: (select /*+ index(QP_LIST_LINES QP_LIST_LINES_U1) */ distinct list_header_id, pricing_phase_id,'Y'
3776: from qp_list_lines
3777: where pricing_phase_id > 1
3778: and qualification_ind in (0,4,20)

Line 3782: FROM qp_list_header_phases

3778: and qualification_ind in (0,4,20)
3779: and list_header_id = g_list_header_id_final_tbl(i)
3780: MINUS
3781: SELECT distinct list_header_id, pricing_phase_id,'Y'
3782: FROM qp_list_header_phases
3783: where list_header_id = g_list_header_id_final_tbl(i)
3784: );
3785: END if;
3786:

Line 4092: FROM qp_list_header_phases

4088: p_pattern_id IN NUMBER) IS
4089:
4090: CURSOR l_phase_id_to_insert_csr IS
4091: SELECT distinct pricing_phase_id, list_header_id
4092: FROM qp_list_header_phases
4093: WHERE list_header_id = p_list_header_id;
4094:
4095: l_exists varchar2(1);
4096: