APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_RESULTS

Line 53: l_lot_number qa_results.lot_number%TYPE;

49:
50: -- OPM Conv R12 Tracking Bug 4345760
51: -- change variable size for lot num
52:
53: l_lot_number qa_results.lot_number%TYPE;
54:
55: l_serial_number VARCHAR2(30);
56: l_insp_result VARCHAR2(80);
57: l_insp_qty NUMBER;

Line 93: -- First, post the Inspection details from qa_results onto

89: l_rti_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE :=NULL;
90: l_rti_loc_id NUMBER := NULL;
91: begin
92:
93: -- First, post the Inspection details from qa_results onto
94: -- the temp table qa_insp_collections_dtl_temp.
95: -- Here we build the detail temp table for the plan.
96:
97: qa_sampling_pkg.post_insp_coll_details(p_collection_id);

Line 385: from qa_results

381: p_plan_id in number) return number is
382:
383: cursor qty(x_coll_id number, x_plan_id number) is
384: select sum(quantity)
385: from qa_results
386: where collection_id = x_coll_id and
387: plan_id = x_plan_id;
388:
389: quantity number;

Line 435: sql_str := 'select sum(quantity) from qa_results ' ||

431: -- can be in any language, we use in statement to check
432: -- inspection result in all possible language
433: --
434:
435: sql_str := 'select sum(quantity) from qa_results ' ||
436: 'where collection_id = :1 and plan_id = :2 and '||
437: result_column || ' in (' || in_str || ' )';
438:
439: