DBA Data[Home] [Help]

APPS.GR_TECHNICAL_PARAMETERS SQL Statements

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

Line: 42

	SELECT	label_description
	FROM	gr_labels_tl
	WHERE	label_code = p_label_code
	AND   	language   = userenv('LANG');
Line: 49

	SELECT	data_type, qcassy_typ_id, lm_unit_code, lowerbound_num,
		upperbound_num, lowerbound_char, upperbound_char, organization_id, tech_parm_id
	FROM 	lm_tech_hdr
	WHERE	organization_id = p_organization_id
	AND	tech_parm_name = X_desc.label_description;
Line: 58

        SELECT 	data_type, qcassy_typ_id, lm_unit_code, lowerbound_num,
		upperbound_num, lowerbound_char, upperbound_char, organization_id, tech_parm_id
	FROM	lm_tech_hdr
	WHERE	organization_id  IS NULL
	AND	tech_parm_name = X_desc.label_description;
Line: 66

	SELECT	b.min_value_num, b.max_value_num, b.target_value_num, b.target_value_char, q.test_unit
	FROM 	gmd_spec_tests_b b, gmd_inventory_spec_vrs v, gmd_specifications_b s, gmd_qc_tests_b q
    WHERE	b.test_id = LocalLabRecord.qcassy_typ_id
	AND 	s.inventory_item_id = p_inventory_item_id
    AND  	b.spec_id = v.spec_id
    AND  	s.spec_id = b.spec_id
    AND	    q.test_id = b.test_id
	AND	   (v.organization_id = p_organization_id OR v.organization_id IS NULL)
	AND	   v.lot_number IS NULL
	AND	   v.subinventory IS NULL;
Line: 80

	SELECT 	num_data
	FROM	lm_item_dat
	WHERE	organization_id = p_organization_id
	AND	tech_parm_name = X_desc.label_description
	AND	inventory_item_id = p_inventory_item_id
        AND tech_parm_id = p_TECH_PARM_ID;
Line: 89

	SELECT	text_data
	FROM 	lm_item_dat
 	WHERE	organization_id = p_organization_id
	AND	tech_parm_name = X_desc.label_description
	AND	inventory_item_id = p_inventory_item_id
        AND tech_parm_id = p_TECH_PARM_ID;
Line: 98

	SELECT	boolean_data
	FROM	lm_item_dat
 	WHERE	organization_id = p_organization_id
	AND	tech_parm_name = X_desc.label_description
	AND	inventory_item_id = p_inventory_item_id
        AND tech_parm_id = p_TECH_PARM_ID;
Line: 107

	SELECT 	tech_parm
	FROM	gr_labels_b
	WHERE	label_code = p_label_code;