[Home] [Help]
122: x_item_category_id number) IS
123: SELECT Nvl(micv.category_id,-1) item_category_id
124: FROM MTL_ITEM_CATEGORIES_V MICV,
125: qa_sl_sp_rcv_criteria qssrc,
126: qa_skiplot_association qsa,
127: qa_skiplot_processes qsp
128: WHERE micv.inventory_item_id= x_item_id AND
129: micv.organization_id= x_organization_id AND
130: qssrc.item_category_id = micv.category_id AND
162: SELECT
163: qsrc.criteria_id criteria_id
164: FROM
165: qa_sl_sp_rcv_criteria qsrc,
166: qa_skiplot_association qsa
167: WHERE
168: qsrc.vendor_id in (-1, x_vendor_id) AND
169: qsrc.vendor_site_id in (-1, x_vendor_site_id) AND
170: qsrc.item_id in (-1, x_item_id)AND
257: primary_lot_qty NUMBER;
258:
259: --
260: -- given a criteria_id, we can get multiple process_ids
261: -- from qa_skiplot_association table. Put lot size and
262: -- effective date as restriction, we will get only one
263: -- process_id if any.
264: -- With this process_id, we can get multiple collection
265: -- plan ids from qa_skiplot_process_plans table.
267: -- Tue Oct 30 17:47:20 PST 2001
268: --
269: cursor the_process (x_c_id number, x_lotsize number) is
270: select qsa.process_id
271: from qa_skiplot_association qsa
272: where qsa.criteria_id = x_c_id and
273: trunc(sysdate) between
274: nvl(trunc(qsa.effective_from), trunc(sysdate)) and
275: nvl(trunc(qsa.effective_to), trunc(sysdate)) and
360: -- SHKALYAN 01-May-2006
361:
362: CURSOR insp_stage(x_crit_id NUMBER, x_process_id NUMBER) IS
363: SELECT INSP_STAGE
364: FROM qa_skiplot_association
365: WHERE criteria_id = x_crit_id
366: AND process_id = x_process_id;
367:
368: -- Bug 3959767 fetches qualification rounds
401: -- bhsankar Wed Aug 22 01:16:48 PDT 2007
402: --
403: CURSOR plan_det (x_pid NUMBER, x_crit_id NUMBER) IS
404: SELECT qspp.process_plan_id
405: FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa
406: WHERE qspp.process_id = qsa.process_id AND
407: qsa.criteria_id = x_crit_id AND
408: qspp.process_id = x_pid;
409: