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 756: /* UPDATE qp_npreq_line_attrs_tmp a

752: AND PRICING_PHASE_ID = p_pricing_phase_id
753: AND CREATED_FROM_LIST_LINE_ID <> v_list_line_id
754: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
755:
756: /* UPDATE qp_npreq_line_attrs_tmp a
757: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UOM_FAILURE
758: WHERE a.LIST_LINE_ID
759: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
760: FROM qp_npreq_ldets_tmp b

Line 990: /* UPDATE qp_npreq_line_attrs_tmp a

986: AND CREATED_FROM_LIST_LINE_ID <> v_list_line_id
987: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
988:
989:
990: /* UPDATE qp_npreq_line_attrs_tmp a
991: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG
992: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
993: FROM qp_npreq_ldets_tmp b
994: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG

Line 999: /* UPDATE qp_npreq_line_attrs_tmp a

995: AND b.CREATED_FROM_LIST_LINE_ID <> v_list_line_id
996: AND b.LINE_INDEX = i.line_index)
997: AND a.LINE_INDEX = i.line_index; */
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
1002: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1003: FROM qp_npreq_ldets_tmp b

Line 1272: UPDATE qp_npreq_line_attrs_tmp

1268:
1269: -- 3773652
1270: -- bulk update, from uom conversion cases
1271: FORALL i in 1..l_upd_line_index_tbl.COUNT
1272: UPDATE qp_npreq_line_attrs_tmp
1273: SET VALUE_FROM = qp_number.number_to_canonical(l_upd_priced_qty_tbl(i))
1274: WHERE LINE_INDEX = l_upd_line_index_tbl(i)
1275: AND CONTEXT = QP_PREQ_GRP.G_PRIC_VOLUME_CONTEXT
1276: AND ATTRIBUTE = QP_PREQ_GRP.G_QUANTITY_ATTRIBUTE

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

1364: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,b.line_detail_index, --3244060
1365: b.CREATED_FROM_LIST_LINE_TYPE, b.OPERAND_CALCULATION_CODE, b.OPERAND_VALUE,a.ESTIM_GL_VALUE ,
1366: a.BENEFIT_PRICE_LIST_LINE_ID,a.PRICE_BREAK_TYPE_CODE,b.LINE_QUANTITY,b.GROUP_QUANTITY,b.GROUP_AMOUNT, --[julin/4240067/4307242]
1367: b.modifier_level_code
1368: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b, qp_npreq_line_attrs_tmp c
1369: WHERE a.LIST_HEADER_ID = b.CREATED_FROM_LIST_HEADER_ID
1370: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
1371: AND b.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1372: AND b.PRICING_PHASE_ID = p_pricing_phase_id

Line 1430: FROM qp_npreq_ldets_tmp a, qp_npreq_line_attrs_tmp b

1426:
1427: -- For bug 2661540
1428: CURSOR get_list_lines_in_order IS
1429: SELECT a.CREATED_FROM_LIST_LINE_ID
1430: FROM qp_npreq_ldets_tmp a, qp_npreq_line_attrs_tmp b
1431: WHERE a.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1432: AND a.PRICING_PHASE_ID = p_pricing_phase_id
1433: AND a.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1434: AND a.LINE_INDEX = p_line_index

Line 1663: /* UPDATE qp_npreq_line_attrs_tmp a

1659: AND INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1660: AND LINE_INDEX = p_line_index
1661: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
1662:
1663: /* UPDATE qp_npreq_line_attrs_tmp a
1664: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1665: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1666: FROM qp_npreq_ldets_tmp b
1667: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL

Line 1672: /* UPDATE qp_npreq_line_attrs_tmp a

1668: AND b.CREATED_FROM_LIST_LINE_ID <> v_list_line_id
1669: AND b.LINE_INDEX = p_line_index)
1670: AND a.LINE_INDEX = p_line_index; */
1671:
1672: /* UPDATE qp_npreq_line_attrs_tmp a
1673: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1674: WHERE a.LIST_LINE_ID
1675: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1676: FROM qp_npreq_ldets_tmp b

Line 1722: UPDATE qp_npreq_line_attrs_tmp

1718: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1719: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1720: WHERE LINE_INDEX = p_line_index_tbl(i);
1721: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1722: UPDATE qp_npreq_line_attrs_tmp
1723: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1724: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1725: WHERE LINE_INDEX = p_line_index_tbl(i);
1726: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST

Line 1887: /* UPDATE qp_npreq_line_attrs_tmp a

1883: AND CREATED_FROM_LIST_LINE_TYPE IN (QP_PREQ_GRP.G_DISCOUNT,QP_PREQ_GRP.G_SURCHARGE)
1884: AND LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE -- Don't delete PBH Children any time
1885: AND PRICING_STATUS_CODE IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL);
1886:
1887: /* UPDATE qp_npreq_line_attrs_tmp a
1888: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
1889: WHERE a.LIST_LINE_ID
1890: IN (SELECT b.CREATED_FROM_LIST_LINE_ID
1891: FROM qp_npreq_ldets_tmp b

Line 1938: /* UPDATE qp_npreq_line_attrs_tmp a

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

Line 2088: /* UPDATE qp_npreq_line_attrs_tmp a

2084: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2085:
2086: --[julin/4116856] moved deletion of un-asked-for promotions to QP_PREQ_GRP
2087:
2088: /* UPDATE qp_npreq_line_attrs_tmp a
2089: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
2090: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
2091: FROM qp_npreq_ldets_tmp b
2092: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL

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

2185: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
2186: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
2187: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2188:
2189: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5

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

2186: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
2187: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2188:
2189: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2194: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6

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

2187: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
2188:
2189: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2194: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2195: */

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

2188:
2189: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2194: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2195: */
2196:

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

2189: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2194: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2195: */
2196:
2197: --UNION

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

2190: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
2191: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
2192: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
2193: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
2194: INDX,QP_Resolve_Incompatability_PVTRUN.resolve_incompatability.each_incomp_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
2195: */
2196:
2197: --UNION
2198:

Line 2209: FROM qp_npreq_line_attrs_tmp b

2205: CURSOR each_incomp_cur(p_incomp_grp_id VARCHAR2,l_manual_dis_flag VARCHAR2) IS
2206: SELECT a.CREATED_FROM_LIST_HEADER_ID,a.CREATED_FROM_LIST_LINE_ID,a.INCOMPATABILITY_GRP_CODE,a.ASK_FOR_FLAG
2207: FROM qp_npreq_ldets_tmp a
2208: WHERE EXISTS (SELECT 'X'
2209: FROM qp_npreq_line_attrs_tmp b
2210: WHERE a.LINE_INDEX = b.LINE_INDEX
2211: AND b.ATTRIBUTE_TYPE = QP_PREQ_GRP.G_QUALIFIER_TYPE
2212: AND b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UNCHANGED
2213: AND b.ATTRIBUTE IN (QP_PREQ_GRP.G_QUAL_ATTRIBUTE1,

Line 2276: /* UPDATE qp_npreq_line_attrs_tmp a

2272:
2273: -- [julin/4116856] moved deletion of un-asked-for promotions to QP_PREQ_GRP
2274:
2275:
2276: /* UPDATE qp_npreq_line_attrs_tmp a
2277: SET a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC
2278: WHERE a.LIST_LINE_ID IN (SELECT b.CREATED_FROM_LIST_LINE_ID
2279: FROM qp_npreq_ldets_tmp b
2280: WHERE b.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC