APPS.QP_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_LIST_LINES

Line 713: list_header_id = (select list_header_id from qp_list_lines

709:
710: --begin fix bug 2746019
711: --l_status_text := v_list_line_id || ',' || v_dup_list_line_id; --fix bug 2746019
712: select name into v_price_list from qp_list_headers_vl where
713: list_header_id = (select list_header_id from qp_list_lines
714: where list_line_id = v_list_line_id);
715:
716: select name into v_dup_price_list from qp_list_headers_vl where
717: list_header_id = (select list_header_id from qp_list_lines

Line 717: list_header_id = (select list_header_id from qp_list_lines

713: list_header_id = (select list_header_id from qp_list_lines
714: where list_line_id = v_list_line_id);
715:
716: select name into v_dup_price_list from qp_list_headers_vl where
717: list_header_id = (select list_header_id from qp_list_lines
718: where list_line_id = v_dup_list_line_id);
719:
720: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
721: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);

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

774:
775: -- begin shu, fix bug 2453250, no price_list_header_id after big search
776: /* Commented for bug#2882115
777: UPDATE qp_npreq_lines_tmp a
778: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
779: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
780: AND a.line_index = i.line_index;
781: */
782: -- end shu fix bug 2453250

Line 949: list_header_id = (select list_header_id from qp_list_lines

945:
946: --begin fix bug 2746019
947: --l_status_text := v_list_line_id || ',' || v_dup_list_line_id; --fix bug 2746019
948: select name into v_price_list from qp_list_headers_vl where
949: list_header_id = (select list_header_id from qp_list_lines
950: where list_line_id = v_list_line_id);
951:
952: select name into v_dup_price_list from qp_list_headers_vl where
953: list_header_id = (select list_header_id from qp_list_lines

Line 953: list_header_id = (select list_header_id from qp_list_lines

949: list_header_id = (select list_header_id from qp_list_lines
950: where list_line_id = v_list_line_id);
951:
952: select name into v_dup_price_list from qp_list_headers_vl where
953: list_header_id = (select list_header_id from qp_list_lines
954: where list_line_id = v_dup_list_line_id);
955:
956: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
957: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);

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

1019:
1020: -- begin shu, fix bug 2453250, no price_list_header_id after big search
1021: /* Commented for bug#2882115
1022: UPDATE qp_npreq_lines_tmp a
1023: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
1024: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
1025: AND a.line_index = i.line_index;
1026: */
1027: -- end shu fix bug 2453250

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

1365: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,PRICING_PHASE_ID,3
1366: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
1367:
1368: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1369: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_lines_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
1370: */
1371: -- For bug#2661540
1372: CURSOR get_list_lines_cur IS
1373: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,b.line_detail_index, --3244060

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

1397: CURSOR get_list_lines_cur IS
1398: SELECT b.CREATED_FROM_LIST_HEADER_ID, b.CREATED_FROM_LIST_LINE_ID,
1399: b.CREATED_FROM_LIST_LINE_TYPE, b.OPERAND_CALCULATION_CODE, b.OPERAND_VALUE,a.ESTIM_GL_VALUE ,
1400: a.BENEFIT_PRICE_LIST_LINE_ID,a.PRICE_BREAK_TYPE_CODE,b.GROUP_QUANTITY,b.GROUP_AMOUNT
1401: FROM QP_LIST_LINES a, qp_npreq_ldets_tmp b
1402: WHERE a.LIST_HEADER_ID = b.CREATED_FROM_LIST_HEADER_ID
1403: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
1404: AND b.CREATED_FROM_LIST_TYPE_CODE not in (QP_PREQ_GRP.G_PRICE_LIST_HEADER,QP_PREQ_GRP.G_AGR_LIST_HEADER)
1405: AND b.PRICING_PHASE_ID = p_pricing_phase_id

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

1417: FROM qp_npreq_lines_tmp
1418: WHERE LINE_INDEX = p_line_index;
1419:
1420: /*
1421: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_price_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
1422: */
1423:
1424: CURSOR get_list_price_cur(p_list_line_id NUMBER) IS
1425: SELECT OPERAND

Line 1426: FROM QP_LIST_LINES

1422: */
1423:
1424: CURSOR get_list_price_cur(p_list_line_id NUMBER) IS
1425: SELECT OPERAND
1426: FROM QP_LIST_LINES
1427: WHERE LIST_LINE_ID = p_list_line_id
1428: AND ARITHMETIC_OPERATOR = QP_PREQ_GRP.G_UNIT_PRICE;
1429:
1430: /*