APPS.QA_MQA_MWA_API SQL Statements

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

Line: 88

		select wlpn.inventory_item_id, msik.concatenated_segments
		from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
		where wlpn.lpn_id = lpnID and
		msik.inventory_item_id = wlpn.inventory_item_id and
		msik.organization_id = orgID;

Line: 95

		select wdd.customer_id, rc.customer_name
		from wsh_delivery_details wdd, qa_customers_lov_v rc
		where wdd.lpn_id = lpnID and
		wdd.customer_id = rc.customer_id;

Line: 101

		select wdd.ship_to_location_id, tl.description
		from wsh_delivery_details wdd, hr_locations_all_tl tl
		where wdd.lpn_id = lpnID and
		wdd.ship_to_location_id = tl.location_id and
        tl.language = userenv('LANG')
		union
		select wdd.ship_to_location_id,
			substr(hz.address1,1,50) description
		from wsh_delivery_details wdd, hz_locations hz
		where wdd.lpn_id = lpnID and
		wdd.ship_to_location_id = hz.location_id;

Line: 202

		SELECT qpt.plan_transaction_id, qp.plan_id
	        FROM   qa_plan_transactions qpt, qa_plans qp
	        WHERE  qpt.transaction_number = txn_number
	        AND    qpt.plan_id = qp.plan_id
	        AND    qp.organization_id = orgID
	        AND    qpt.enabled_flag = 1;

Line: 308

        SELECT qpct.operator,
               qpct.Low_Value,
               qpct.High_Value ,
               qc.datatype,
               qc.char_id
        FROM   qa_plan_collection_triggers qpct,
               qa_chars qc
        WHERE  qpct.Collection_Trigger_ID = qc.char_id and
               qpct.plan_transaction_id = p_plan_txn_id) LOOP

        IF NOT elements.EXISTS(plan_record.char_id) THEN
            RETURN 'F';