DBA Data[Home] [Help]

APPS.GML_RQ_DB_COMMON SQL Statements

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

Line: 65

	select 	whse_code,
		orgn_code
	into	v_whse_code,
		v_orgn_code
	from	ic_whse_mst
	where	mtl_organization_id = x_org_id;
Line: 73

	select 	item_um,
		dualum_ind
	into	v_primary_opm_uom,
		v_dual_uom_type
	from	ic_item_mst
	where	item_id = x_item_id;