DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on QP_PREQ_LINES_TMP

Line 2058: FROM qp_preq_lines_tmp;

2054: END IF;
2055:
2056: SELECT COUNT(*)
2057: INTO i
2058: FROM qp_preq_lines_tmp;
2059:
2060: IF (l_debug = 1) THEN
2061: print_debug('MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || TO_CHAR(i));
2062: END IF;

Line 2061: print_debug('MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || TO_CHAR(i));

2057: INTO i
2058: FROM qp_preq_lines_tmp;
2059:
2060: IF (l_debug = 1) THEN
2061: print_debug('MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || TO_CHAR(i));
2062: END IF;
2063: EXCEPTION
2064: WHEN fnd_api.g_exc_error THEN
2065: RAISE fnd_api.g_exc_error;

Line 2112: FROM qp_preq_lines_tmp lines

2108: , g_unit_selling_percent_tbl(i)
2109: , g_currency_code_tbl(i)
2110: , g_pricing_status_code_tbl(i)
2111: , g_pricing_status_text_tbl(i)
2112: FROM qp_preq_lines_tmp lines
2113: WHERE lines.line_id = g_line_id_tbl(i)
2114: AND lines.line_type_code = g_line_type_code_tbl(i); /* For bug 4335863 */
2115: /* End OPM bug 4875081*/
2116: ELSE

Line 2143: FROM qp_preq_lines_tmp lines

2139: , g_unit_selling_percent_tbl(i)
2140: , g_currency_code_tbl(i)
2141: , g_pricing_status_code_tbl(i)
2142: , g_pricing_status_text_tbl(i)
2143: FROM qp_preq_lines_tmp lines
2144: WHERE lines.line_id = g_line_id_tbl(i)
2145: AND lines.line_type_code = g_line_type_code_tbl(i); /* For bug 4335863 */
2146: END IF;
2147: EXCEPTION