DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on QP_PREQ_LINES_TMP

Line 2125: FROM qp_preq_lines_tmp;

2121: END IF;
2122:
2123: SELECT COUNT(*)
2124: INTO i
2125: FROM qp_preq_lines_tmp;
2126:
2127: IF (l_debug = 1) THEN
2128: print_debug('MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || TO_CHAR(i));
2129: END IF;

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

2124: INTO i
2125: FROM qp_preq_lines_tmp;
2126:
2127: IF (l_debug = 1) THEN
2128: print_debug('MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || TO_CHAR(i));
2129: END IF;
2130: EXCEPTION
2131: WHEN fnd_api.g_exc_error THEN
2132: RAISE fnd_api.g_exc_error;

Line 2179: FROM qp_preq_lines_tmp lines

2175: , g_unit_selling_percent_tbl(i)
2176: , g_currency_code_tbl(i)
2177: , g_pricing_status_code_tbl(i)
2178: , g_pricing_status_text_tbl(i)
2179: FROM qp_preq_lines_tmp lines
2180: WHERE lines.line_id = g_line_id_tbl(i)
2181: AND lines.line_type_code = g_line_type_code_tbl(i); /* For bug 4335863 */
2182: /* End OPM bug 4875081*/
2183: ELSE

Line 2210: FROM qp_preq_lines_tmp lines

2206: , g_unit_selling_percent_tbl(i)
2207: , g_currency_code_tbl(i)
2208: , g_pricing_status_code_tbl(i)
2209: , g_pricing_status_text_tbl(i)
2210: FROM qp_preq_lines_tmp lines
2211: WHERE lines.line_id = g_line_id_tbl(i)
2212: AND lines.line_type_code = g_line_type_code_tbl(i); /* For bug 4335863 */
2213: END IF;
2214: EXCEPTION