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 84: -- First, post the Inspection details from qa_results onto

80: l_rti_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE :=NULL;
81: l_rti_loc_id NUMBER := NULL;
82: begin
83:
84: -- First, post the Inspection details from qa_results onto
85: -- the temp table qa_insp_collections_dtl_temp.
86: -- Here we build the detail temp table for the plan.
87:
88: qa_sampling_pkg.post_insp_coll_details(p_collection_id);

Line 367: from qa_results

363: p_plan_id in number) return number is
364:
365: cursor qty(x_coll_id number, x_plan_id number) is
366: select sum(quantity)
367: from qa_results
368: where collection_id = x_coll_id and
369: plan_id = x_plan_id;
370:
371: quantity number;

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

413: -- can be in any language, we use in statement to check
414: -- inspection result in all possible language
415: --
416:
417: sql_str := 'select sum(quantity) from qa_results ' ||
418: 'where collection_id = :1 and plan_id = :2 and '||
419: result_column || ' in (' || in_str || ' )';
420:
421: