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_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_NPREQ_LINE_ATTRS_TMP

Line 19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1

15:
16: V_QUALIFIER_TYPE CONSTANT VARCHAR2(240) := 'QUALIFIER';
17: /*
18:
19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4
23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5

Line 20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2

16: V_QUALIFIER_TYPE CONSTANT VARCHAR2(240) := 'QUALIFIER';
17: /*
18:
19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4
23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5
24:

Line 21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3

17: /*
18:
19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4
23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5
24:
25: UNION

Line 22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4

18:
19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4
23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5
24:
25: UNION
26: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

Line 23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5

19: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
20: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
21: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
22: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_HEADER_ID,4
23: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_line_attrs_tmp_N1,LIST_LINE_ID,5
24:
25: UNION
26: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
27: INDX,QP_Resolve_Incompatability_PVTRUN.precedence_for_list_line.precedence_for_line_cur,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

Line 37: FROM qp_npreq_line_attrs_tmp a

33: --Precedence for line cur
34: -- Pricing Phase Change
35: CURSOR precedence_for_line_cur IS
36: SELECT nvl(a.QUALIFIER_PRECEDENCE,5000) PRECED
37: FROM qp_npreq_line_attrs_tmp a
38: WHERE a.LIST_LINE_ID = p_list_line_id
39: AND a.LIST_HEADER_ID = p_list_header_id
40: AND a.ATTRIBUTE_TYPE = 'QUALIFIER'
41: AND a.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id

Line 77: FROM qp_npreq_line_attrs_tmp a

73:
74:
75: CURSOR get_product_details_cur(p_list_line_id number) IS
76: SELECT product_uom_code,attribute,value_from inventory_item_id
77: FROM qp_npreq_line_attrs_tmp a
78: WHERE a.LIST_LINE_ID = p_list_line_id
79: AND a.LINE_INDEX = p_line_index
80: AND a.ATTRIBUTE_TYPE = 'PRODUCT'
81: AND a.PRICING_PHASE_ID = 1

Line 86: FROM qp_npreq_line_attrs_tmp

82: AND a.PRICING_STATUS_CODE = 'N';
83:
84: CURSOR get_inventory_item_id_cur(p_line_index NUMBER) IS
85: SELECT value_from
86: FROM qp_npreq_line_attrs_tmp
87: WHERE line_index = p_line_index
88: AND attribute_type = QP_PREQ_GRP.G_PRODUCT_TYPE
89: AND context = 'ITEM'
90: AND attribute = 'PRICING_ATTRIBUTE1'

Line 132: -- Bug 2687089 Commented exists and addded join with qp_npreq_line_attrs_tmp

128: -- shulin
129: -- uom match comdition is added, when order_uom does not match product uom (uom conversion should happen)
130: -- this cursor should not return list_line_id, which will cause UOM conversion not happening
131: -- Bug 2490074 Join with qp_npreq_ldets_tmp is added in 1st part of union to pick only undeleted lines.
132: -- Bug 2687089 Commented exists and addded join with qp_npreq_line_attrs_tmp
133: OPEN l_precedence_for_line_cur FOR
134: SELECT distinct nvl(a.QUALIFIER_PRECEDENCE,5000) PRECED , a.LIST_LINE_ID , -99999 QUAL_PRECED
135: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp c , qp_npreq_line_attrs_tmp b
136: WHERE a.ATTRIBUTE_TYPE = 'QUALIFIER'

Line 135: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp c , qp_npreq_line_attrs_tmp b

131: -- Bug 2490074 Join with qp_npreq_ldets_tmp is added in 1st part of union to pick only undeleted lines.
132: -- Bug 2687089 Commented exists and addded join with qp_npreq_line_attrs_tmp
133: OPEN l_precedence_for_line_cur FOR
134: SELECT distinct nvl(a.QUALIFIER_PRECEDENCE,5000) PRECED , a.LIST_LINE_ID , -99999 QUAL_PRECED
135: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp c , qp_npreq_line_attrs_tmp b
136: WHERE a.ATTRIBUTE_TYPE = 'QUALIFIER'
137: AND a.INCOMPATABILITY_GRP_CODE = 'EXCL'
138: AND a.PRICING_PHASE_ID = 1
139: AND a.PRICING_STATUS_CODE = 'N'

Line 150: FROM qp_npreq_line_attrs_tmp b

146: AND b.PRODUCT_UOM_CODE = p_order_uom_code
147: AND b.LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE
148: AND b.list_line_id = a.LIST_LINE_ID
149: /* AND EXISTS (SELECT 'X' -- uom match, shulin
150: FROM qp_npreq_line_attrs_tmp b
151: WHERE LINE_INDEX = p_line_index
152: AND PRICING_STATUS_CODE = 'N'
153: AND INCOMPATABILITY_GRP_CODE = 'EXCL'
154: AND PRICING_PHASE_ID = 1

Line 167: FROM qp_npreq_line_attrs_tmp c,qp_npreq_ldets_tmp b

163: SELECT z.PRECED , z.LIST_LINE_ID , z.QUALIFIER_PRECEDENCE QUAL_PRECED
164: FROM (
165: SELECT /*+ ORDERED USE_NL(b) index(c qp_preq_line_attrs_tmp_N5) rec_exist_with_order_uom_cur */
166: nvl(b.PRODUCT_PRECEDENCE,5000) PRECED , c.LIST_LINE_ID , nvl(c.QUALIFIER_PRECEDENCE,-99999) QUALIFIER_PRECEDENCE
167: FROM qp_npreq_line_attrs_tmp c,qp_npreq_ldets_tmp b
168: WHERE c.PRICING_PHASE_ID = L_PRICE_LIST_PHASE_ID
169: AND c.PRODUCT_UOM_CODE = p_order_uom_code
170: AND c.ATTRIBUTE_TYPE = QP_PREQ_GRP.G_PRODUCT_TYPE
171: AND c.LINE_INDEX = p_line_index

Line 188: FROM qp_npreq_line_attrs_tmp a, qp_npreq_ldets_tmp c, qp_npreq_line_attrs_tmp b

184: END IF;
185: /* Modified cursor l_precedence_for_line_cur for 2780293 */
186: OPEN l_precedence_for_line_cur FOR
187: SELECT nvl(a.QUALIFIER_PRECEDENCE,5000) PRECED , a.LIST_LINE_ID , -99999 QUAL_PRECED
188: FROM qp_npreq_line_attrs_tmp a, qp_npreq_ldets_tmp c, qp_npreq_line_attrs_tmp b
189: WHERE a.ATTRIBUTE_TYPE = 'QUALIFIER'
190: AND a.INCOMPATABILITY_GRP_CODE = 'EXCL'
191: AND a.PRICING_PHASE_ID = 1
192: AND a.PRICING_STATUS_CODE = 'N'

Line 211: FROM qp_npreq_line_attrs_tmp b,qp_npreq_ldets_tmp c

207: SELECT z.PRECED , z.LIST_LINE_ID , z.QUALIFIER_PRECEDENCE QUAL_PRECED
208: FROM(
209: SELECT /*+ ORDERED USE_NL(c d) index(b qp_preq_line_attrs_tmp_N5) rec_exist_with_pri_flag_cur */
210: nvl(c.PRODUCT_PRECEDENCE,5000) PRECED , b.LIST_LINE_ID , nvl(b.QUALIFIER_PRECEDENCE ,-99999) QUALIFIER_PRECEDENCE
211: FROM qp_npreq_line_attrs_tmp b,qp_npreq_ldets_tmp c
212: WHERE b.PRIMARY_UOM_FLAG = QP_PREQ_GRP.G_YES
213: AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
214: AND b.CONTEXT = 'ITEM'
215: AND b.ATTRIBUTE_TYPE = QP_PREQ_GRP.G_PRODUCT_TYPE

Line 426: /* UPDATE qp_npreq_line_attrs_tmp a

422: AND LINE_INDEX = p_line_index
423: AND PRICING_PHASE_ID = p_pricing_phase_id
424: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
425:
426: /* UPDATE qp_npreq_line_attrs_tmp a
427: SET a.PRICING_STATUS_CODE = p_status_code
428: WHERE a.LIST_LINE_ID
429: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
430: FROM qp_npreq_ldets_tmp b

Line 473: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1

469: --AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UNCHANGED
470: ORDER BY a.LINE_INDEX;
471:
472: /*
473: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
474: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
475: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
476: */
477:

Line 474: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2

470: ORDER BY a.LINE_INDEX;
471:
472: /*
473: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
474: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
475: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
476: */
477:
478: CURSOR get_attribute_count_cur(p_line_index NUMBER , p_list_line_id NUMBER) IS

Line 475: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3

471:
472: /*
473: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
474: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
475: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.get_attribute_count_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
476: */
477:
478: CURSOR get_attribute_count_cur(p_line_index NUMBER , p_list_line_id NUMBER) IS
479: SELECT COUNT(*) ATTRIBUTE_COUNT

Line 480: FROM qp_npreq_line_attrs_tmp

476: */
477:
478: CURSOR get_attribute_count_cur(p_line_index NUMBER , p_list_line_id NUMBER) IS
479: SELECT COUNT(*) ATTRIBUTE_COUNT
480: FROM qp_npreq_line_attrs_tmp
481: WHERE LIST_LINE_ID = p_list_line_id
482: AND LINE_INDEX = p_line_index
483: AND ATTRIBUTE_TYPE = QP_PREQ_GRP.G_PRICING_TYPE
484: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;

Line 763: /* UPDATE qp_npreq_line_attrs_tmp a

759: AND PRICING_PHASE_ID = p_pricing_phase_id
760: AND CREATED_FROM_LIST_LINE_ID <> v_list_line_id
761: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
762:
763: /* UPDATE qp_npreq_line_attrs_tmp a
764: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UOM_FAILURE
765: WHERE a.LIST_LINE_ID
766: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
767: FROM qp_npreq_ldets_tmp b

Line 999: /* UPDATE qp_npreq_line_attrs_tmp a

995: AND CREATED_FROM_LIST_LINE_ID <> v_list_line_id
996: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
997:
998:
999: /* UPDATE qp_npreq_line_attrs_tmp a
1000: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG
1001: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1002: FROM qp_npreq_ldets_tmp b
1003: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG

Line 1008: /* UPDATE qp_npreq_line_attrs_tmp a

1004: AND b.CREATED_FROM_LIST_LINE_ID <> v_list_line_id
1005: AND b.LINE_INDEX = i.line_index)
1006: AND a.LINE_INDEX = i.line_index; */
1007:
1008: /* UPDATE qp_npreq_line_attrs_tmp a
1009: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG
1010: WHERE a.LIST_LINE_ID
1011: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1012: FROM qp_npreq_ldets_tmp b

Line 1281: UPDATE qp_npreq_line_attrs_tmp

1277:
1278: -- 3773652
1279: -- bulk update, from uom conversion cases
1280: FORALL i in 1..l_upd_line_index_tbl.COUNT
1281: UPDATE qp_npreq_line_attrs_tmp
1282: SET VALUE_FROM = qp_number.number_to_canonical(l_upd_priced_qty_tbl(i))
1283: WHERE LINE_INDEX = l_upd_line_index_tbl(i)
1284: AND CONTEXT = QP_PREQ_GRP.G_PRIC_VOLUME_CONTEXT
1285: AND ATTRIBUTE = QP_PREQ_GRP.G_QUANTITY_ATTRIBUTE

Line 1377: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b, qp_npreq_line_attrs_tmp c

1373: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,b.line_detail_index, --3244060
1374: b.CREATED_FROM_LIST_LINE_TYPE, b.OPERAND_CALCULATION_CODE, b.OPERAND_VALUE,a.ESTIM_GL_VALUE ,
1375: a.BENEFIT_PRICE_LIST_LINE_ID,a.PRICE_BREAK_TYPE_CODE,b.LINE_QUANTITY,b.GROUP_QUANTITY,b.GROUP_AMOUNT, --[julin/4240067/4307242]
1376: b.modifier_level_code
1377: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b, qp_npreq_line_attrs_tmp c
1378: WHERE a.LIST_HEADER_ID = b.CREATED_FROM_LIST_HEADER_ID
1379: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
1380: AND b.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1381: AND b.PRICING_PHASE_ID = p_pricing_phase_id

Line 1439: FROM qp_npreq_ldets_tmp a, qp_npreq_line_attrs_tmp b

1435:
1436: -- For bug 2661540
1437: CURSOR get_list_lines_in_order IS
1438: SELECT a.CREATED_FROM_LIST_LINE_ID
1439: FROM qp_npreq_ldets_tmp a, qp_npreq_line_attrs_tmp b
1440: WHERE a.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1441: AND a.PRICING_PHASE_ID = p_pricing_phase_id
1442: AND a.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1443: AND a.LINE_INDEX = p_line_index

Line 1699: /* UPDATE qp_npreq_line_attrs_tmp a

1695: END IF;
1696: --print_tmp_tabs();
1697: --smbalara start 11924159 END
1698:
1699: /* UPDATE qp_npreq_line_attrs_tmp a
1700: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1701: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1702: FROM qp_npreq_ldets_tmp b
1703: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL

Line 1708: /* UPDATE qp_npreq_line_attrs_tmp a

1704: AND b.CREATED_FROM_LIST_LINE_ID <> v_list_line_id
1705: AND b.LINE_INDEX = p_line_index)
1706: AND a.LINE_INDEX = p_line_index; */
1707:
1708: /* UPDATE qp_npreq_line_attrs_tmp a
1709: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1710: WHERE a.LIST_LINE_ID
1711: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1712: FROM qp_npreq_ldets_tmp b

Line 1758: UPDATE qp_npreq_line_attrs_tmp

1754: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1755: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1756: WHERE LINE_INDEX = p_line_index_tbl(i);
1757: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1758: UPDATE qp_npreq_line_attrs_tmp
1759: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1760: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1761: WHERE LINE_INDEX = p_line_index_tbl(i);
1762: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST

Line 1937: /* UPDATE qp_npreq_line_attrs_tmp a

1933: AND CREATED_FROM_LIST_LINE_TYPE IN (QP_PREQ_GRP.G_DISCOUNT,QP_PREQ_GRP.G_SURCHARGE)
1934: AND LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE -- Don't delete PBH Children any time
1935: AND PRICING_STATUS_CODE IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL);
1936:
1937: /* UPDATE qp_npreq_line_attrs_tmp a
1938: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
1939: WHERE a.LIST_LINE_ID
1940: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1941: FROM qp_npreq_ldets_tmp b

Line 1999: /* UPDATE qp_npreq_line_attrs_tmp a

1995: AND CREATED_FROM_LIST_LINE_TYPE IN (QP_PREQ_GRP.G_DISCOUNT,QP_PREQ_GRP.G_SURCHARGE)
1996: AND LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE -- Don't delete PBH Children any time
1997: AND PRICING_STATUS_CODE IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL);
1998:
1999: /* UPDATE qp_npreq_line_attrs_tmp a
2000: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
2001: WHERE a.LIST_LINE_ID
2002: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
2003: FROM qp_npreq_ldets_tmp b

Line 2149: /* UPDATE qp_npreq_line_attrs_tmp a

2145: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2146:
2147: --[julin/4116856] moved deletion of un-asked-for promotions to QP_PREQ_GRP
2148:
2149: /* UPDATE qp_npreq_line_attrs_tmp a
2150: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
2151: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
2152: FROM qp_npreq_ldets_tmp b
2153: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL

Line 2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

2246: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
2247: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
2248: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2249:
2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5

Line 2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

2247: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
2248: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2249:
2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6

Line 2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

2248: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2249:
2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2256: */

Line 2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4

2249:
2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2256: */
2257:

Line 2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5

2250: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2256: */
2257:
2258: --UNION

Line 2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6

2251: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2252: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2253: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2254: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2255: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2256: */
2257:
2258: --UNION
2259:

Line 2270: FROM qp_npreq_line_attrs_tmp b

2266: CURSOR each_incomp_cur(p_incomp_grp_id VARCHAR2,l_manual_dis_flag VARCHAR2) IS
2267: SELECT a.CREATED_FROM_LIST_HEADER_ID,a.CREATED_FROM_LIST_LINE_ID,a.INCOMPATABILITY_GRP_CODE,a.ASK_FOR_FLAG
2268: FROM qp_npreq_ldets_tmp a
2269: WHERE EXISTS (SELECT 'X'
2270: FROM qp_npreq_line_attrs_tmp b
2271: WHERE a.LINE_INDEX = b.LINE_INDEX
2272: AND b.ATTRIBUTE_TYPE = QP_PREQ_GRP.G_QUALIFIER_TYPE
2273: AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UNCHANGED
2274: AND b.ATTRIBUTE IN (QP_PREQ_GRP.G_QUAL_ATTRIBUTE1,

Line 2337: /* UPDATE qp_npreq_line_attrs_tmp a

2333:
2334: -- [julin/4116856] moved deletion of un-asked-for promotions to QP_PREQ_GRP
2335:
2336:
2337: /* UPDATE qp_npreq_line_attrs_tmp a
2338: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC
2339: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
2340: FROM qp_npreq_ldets_tmp b
2341: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC