APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_RCV_RESULTS

Line 39: from qa_skiplot_rcv_results qsrr

35: prev_date date;
36:
37: cursor p (p_criteria_id in number, p_receipt_date in date) is
38: select qsrr.receipt_date
39: from qa_skiplot_rcv_results qsrr
40: where insp_lot_id = (select max(qsrr2.insp_lot_id)
41: from qa_skiplot_rcv_results qsrr2
42: where qsrr2.criteria_id = p_criteria_id and
43: qsrr2.receipt_date < p_receipt_date);

Line 41: from qa_skiplot_rcv_results qsrr2

37: cursor p (p_criteria_id in number, p_receipt_date in date) is
38: select qsrr.receipt_date
39: from qa_skiplot_rcv_results qsrr
40: where insp_lot_id = (select max(qsrr2.insp_lot_id)
41: from qa_skiplot_rcv_results qsrr2
42: where qsrr2.criteria_id = p_criteria_id and
43: qsrr2.receipt_date < p_receipt_date);
44:
45: begin

Line 112: from qa_skiplot_rcv_results q1

108: --
109: cursor new_start_lot (x_rule_start_lotid number, x_criteria_id number,
110: x_process_id number) is
111: select q1.insp_lot_id, q1.receipt_date
112: from qa_skiplot_rcv_results q1
113: where q1.insp_lot_id = (select min(q2.insp_lot_id)
114: from qa_skiplot_rcv_results q2
115: where q2.insp_lot_id > x_rule_start_lotid and
116: q2.criteria_id = x_criteria_id and

Line 114: from qa_skiplot_rcv_results q2

110: x_process_id number) is
111: select q1.insp_lot_id, q1.receipt_date
112: from qa_skiplot_rcv_results q1
113: where q1.insp_lot_id = (select min(q2.insp_lot_id)
114: from qa_skiplot_rcv_results q2
115: where q2.insp_lot_id > x_rule_start_lotid and
116: q2.criteria_id = x_criteria_id and
117: q2.process_id = x_process_id);
118: