APPS.QA_SS_OM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

	SELECT 'Y'
	from QA_RESULTS QR
	where QR.So_Header_Id = P_So_Header_Id
	AND Rownum <= 1;

Line: 46

	SELECT 'Y'
	from QA_RESULTS QR
	where QR.So_Header_Id = P_So_Header_Id
	AND QR.Item_Id = p_item_id
	AND Rownum <= 1;

Line: 97

	SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
	from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
	where QR.So_Header_Id = to_number(Pk1)
	and qr.plan_id = qp.plan_id
	and qp.plan_type_code = fcl.lookup_code
	and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'
	order by qp.name;

Line: 155

	SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
	from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
	where QR.So_Header_Id = to_number(Pk1)
	AND   qr.item_id = to_number(pk3)
	and qr.plan_id = qp.plan_id
	and  qp.plan_type_code = fcl.lookup_code
	and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'
	order by qp.name;

Line: 299

	Select 'Y'
	From QA_RESULTS QR
	Where QR.So_header_id = p_mtl_sales_ord_id
	AND QR.plan_id = x_Pid;

Line: 335

	Select 'Y'
	From QA_RESULTS QR
	Where QR.so_header_id = p_mtl_sales_ord_id
	AND  QR.Item_Id = x_item_id
	AND  QR.Plan_ID = x_Pid;