APPS.QA_SS_OM dependencies on QA_RESULTS

Line 15: from QA_RESULTS QR

11: -- This cursor is to verify if there is data in qr for
12: -- the given so header id
13: CURSOR om_plans_cur IS
14: SELECT 'Y'
15: from QA_RESULTS QR
16: where QR.So_Header_Id = P_So_Header_Id
17: AND Rownum <= 1;
18:
19: BEGIN

Line 47: from QA_RESULTS QR

43: -- This cursor sees if there is row in qr for the
44: -- given so header id and item id combination
45: CURSOR om_plans_cur IS
46: SELECT 'Y'
47: from QA_RESULTS QR
48: where QR.So_Header_Id = P_So_Header_Id
49: AND QR.Item_Id = p_item_id
50: AND Rownum <= 1;
51:

Line 98: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl

94: -- Fetch plans matching the so header id criteria
95: -- also get the plan name, description and type(meaning)
96: CURSOR om_plans_cur IS
97: SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
98: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
99: where QR.So_Header_Id = to_number(Pk1)
100: and qr.plan_id = qp.plan_id
101: and qp.plan_type_code = fcl.lookup_code
102: and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'

Line 156: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl

152: -- Fetch plans matching the so header id and itemid criteria
153: -- also get the plan name, description and type(meaning)
154: CURSOR om_plans_cur IS
155: SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
156: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
157: where QR.So_Header_Id = to_number(Pk1)
158: AND qr.item_id = to_number(pk3)
159: and qr.plan_id = qp.plan_id
160: and qp.plan_type_code = fcl.lookup_code

Line 300: From QA_RESULTS QR

296: l_mtl_sales_ord_id NUMBER := -99;
297:
298: CURSOR om_plans_cur(p_mtl_sales_ord_id IN NUMBER) IS
299: Select 'Y'
300: From QA_RESULTS QR
301: Where QR.So_header_id = p_mtl_sales_ord_id
302: AND QR.plan_id = x_Pid;
303:
304: BEGIN

Line 310: qa_results_interface_pkg.OEHeader_to_MTLSales

306: return 'N';
307: end if;
308:
309: l_mtl_sales_ord_id :=
310: qa_results_interface_pkg.OEHeader_to_MTLSales
311: ( x_so_header_id );
312:
313: open om_plans_cur (l_mtl_sales_ord_id);
314: fetch om_plans_cur into plan_applicable;

Line 336: From QA_RESULTS QR

332: -- USing the sales _order_id instead of header_id
333: --
334: CURSOR om_plans_cur(p_mtl_sales_ord_id IN NUMBER) IS
335: Select 'Y'
336: From QA_RESULTS QR
337: Where QR.so_header_id = p_mtl_sales_ord_id
338: AND QR.Item_Id = x_item_id
339: AND QR.Plan_ID = x_Pid;
340:

Line 351: qa_results_interface_pkg.OEHeader_to_MTLSales

347: -- bug 11831190
348: -- Deriving the sales_order_id based on the header_id
349: --
350: l_mtl_sales_ord_id :=
351: qa_results_interface_pkg.OEHeader_to_MTLSales
352: ( x_so_header_id );
353:
354: open om_plans_cur(l_mtl_sales_ord_id);
355: fetch om_plans_cur into plan_applicable;