APPS.QP_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_LIST_LINES

Line 706: list_header_id = (select list_header_id from qp_list_lines

702:
703: --begin fix bug 2746019
704: --l_status_text := v_list_line_id || ',' || v_dup_list_line_id; --fix bug 2746019
705: select name into v_price_list from qp_list_headers_vl where
706: list_header_id = (select list_header_id from qp_list_lines
707: where list_line_id = v_list_line_id);
708:
709: select name into v_dup_price_list from qp_list_headers_vl where
710: list_header_id = (select list_header_id from qp_list_lines

Line 710: list_header_id = (select list_header_id from qp_list_lines

706: list_header_id = (select list_header_id from qp_list_lines
707: where list_line_id = v_list_line_id);
708:
709: select name into v_dup_price_list from qp_list_headers_vl where
710: list_header_id = (select list_header_id from qp_list_lines
711: where list_line_id = v_dup_list_line_id);
712:
713: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
714: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);

Line 771: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )

767:
768: -- begin shu, fix bug 2453250, no price_list_header_id after big search
769: /* Commented for bug#2882115
770: UPDATE qp_npreq_lines_tmp a
771: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
772: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
773: AND a.line_index = i.line_index;
774: */
775: -- end shu fix bug 2453250

Line 940: list_header_id = (select list_header_id from qp_list_lines

936:
937: --begin fix bug 2746019
938: --l_status_text := v_list_line_id || ',' || v_dup_list_line_id; --fix bug 2746019
939: select name into v_price_list from qp_list_headers_vl where
940: list_header_id = (select list_header_id from qp_list_lines
941: where list_line_id = v_list_line_id);
942:
943: select name into v_dup_price_list from qp_list_headers_vl where
944: list_header_id = (select list_header_id from qp_list_lines

Line 944: list_header_id = (select list_header_id from qp_list_lines

940: list_header_id = (select list_header_id from qp_list_lines
941: where list_line_id = v_list_line_id);
942:
943: select name into v_dup_price_list from qp_list_headers_vl where
944: list_header_id = (select list_header_id from qp_list_lines
945: where list_line_id = v_dup_list_line_id);
946:
947: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
948: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);

Line 1014: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )

1010:
1011: -- begin shu, fix bug 2453250, no price_list_header_id after big search
1012: /* Commented for bug#2882115
1013: UPDATE qp_npreq_lines_tmp a
1014: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
1015: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
1016: AND a.line_index = i.line_index;
1017: */
1018: -- end shu fix bug 2453250

Line 1360: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

1356: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,PRICING_PHASE_ID,3
1357: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
1358:
1359: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1360: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
1361: */
1362: -- For bug#2661540
1363: CURSOR get_list_lines_cur IS
1364: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,b.line_detail_index, --3244060

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 1392: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b

1388: CURSOR get_list_lines_cur IS
1389: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,
1390: b.CREATED_FROM_LIST_LINE_TYPE, b.OPERAND_CALCULATION_CODE, b.OPERAND_VALUE,a.ESTIM_GL_VALUE ,
1391: a.BENEFIT_PRICE_LIST_LINE_ID,a.PRICE_BREAK_TYPE_CODE,b.GROUP_QUANTITY,b.GROUP_AMOUNT
1392: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b
1393: WHERE a.LIST_HEADER_ID = b.CREATED_FROM_LIST_HEADER_ID
1394: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
1395: AND b.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1396: AND b.PRICING_PHASE_ID = p_pricing_phase_id

Line 1412: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_price_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

1408: FROM qp_npreq_lines_tmp
1409: WHERE LINE_INDEX = p_line_index;
1410:
1411: /*
1412: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_price_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
1413: */
1414:
1415: CURSOR get_list_price_cur(p_list_line_id NUMBER) IS
1416: SELECT OPERAND

Line 1417: FROM QP_LIST_LINES

1413: */
1414:
1415: CURSOR get_list_price_cur(p_list_line_id NUMBER) IS
1416: SELECT OPERAND
1417: FROM QP_LIST_LINES
1418: WHERE LIST_LINE_ID = p_list_line_id
1419: AND ARITHMETIC_OPERATOR = QP_PREQ_GRP.G_UNIT_PRICE;
1420:
1421: /*